Skip to main content
Solved

Delete values

N

Hi!

I have to extract data and write it into excel sheet. I got to the point where I have the information ready but I need to delete missing values and move the features so the table looks different. I add an example.

This is what I get:

Days

Months

City

<Missing>

March

<Missing>

<Missing>

March

<Missing>

<Missing>

March

Paris

Monday

March

Paris

Wednesday

<Missing>

Paris

Saturday

<Missing>

Paris

<Missing>

<Missing>

<Missing>

<Missing>

<Missing>

<Missing>

<Missing>

<Missing>

<Missing>

 

And this is what I want to write into my writer.

 

Days

Months

City

Monday

March

Paris

Wednesday

March

Paris

Saturday

March

Paris

 

March

Paris

Maybe it is easy but I´m still learning... Any help here??

Thanks in advance!!

Best answer by ebygomm

This should let you select which attributes you want to remove blanks from

delete values python.fmw

View original
danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme
Did this help you find an answer to your question?

7 replies

cdalessandro
Participant
Forum|alt.badge.img+4
  • cdalessandroParticipant
  • Participant
  • March 31, 2020

Working "vertically" on FME is always not simply. I wrote a WB for You but it doesen't work dinamically. Let me know nullvalueskip.zip

N
  • ninani
  • Author
  • March 31, 2020
cdalessandro wrote:

Working "vertically" on FME is always not simply. I wrote a WB for You but it doesen't work dinamically. Let me know nullvalueskip.zip

Hi @cdalessandro. Thanks for your quick response!! It does not make any difference in the result so I´ll try to find other options. All suggestions/ideas are welcome :)

warrendev
Enthusiast
Forum|alt.badge.img+23
  • warrendevEnthusiast
  • Enthusiast
  • April 1, 2020

@ninani,

 

 

I have uploaded an example workspace that should help to get your desired output. example.fmwt

 

 

Input

 

 

Output

 

N
  • ninani
  • Author
  • April 9, 2020

Hi @warrengis! I have modified the python according to my real attribute names and I get the error "Python Exception <SyntaxError>: can't assign to operator (<string>, line 8)"

I have no idea why that happens. My script looks like this and it is done following the same steps than in yours. Why does not it work?

I have to say that I have no idea how to use python so...

I hope somebody can help me.

Thanks!!!

 

 

ebygomm
Influencer
Forum|alt.badge.img+31
  • ebygommInfluencer
  • Influencer
  • Best Answer
  • April 9, 2020

This should let you select which attributes you want to remove blanks from

delete values python.fmw

hrgisolutions
1 person upvoted this
  • hrgisolutions
    hrgisolutions
N
  • ninani
  • Author
  • April 9, 2020
ebygomm wrote:

This should let you select which attributes you want to remove blanks from

delete values python.fmw

Hi @ebygomm!

This works and I get what I need. Thanks a lot!!!

hrgisolutions
Contributor
Forum|alt.badge.img+1
ebygomm wrote:

This should let you select which attributes you want to remove blanks from

delete values python.fmw

Hi @ebygomm, I sent you a dm, but in case you didn’t see it, and see this first, could you please repost your delete values python.fmw I can’t seem to download it.

(Or, if someone else sees this and has it could they please share it.)

Many thanks

evieatsafe
mark2atsafe
2 people upvoted this
  • evieatsafe
    evieatsafe
  • mark2atsafe
    mark2atsafe

Reply


Helpful Members This Week

Community Stats

30,921
Posts
117,179
Replies
38,725
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.