Solved

Delete values

  • 31 March 2020
  • 7 replies
  • 112 views

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!!

icon

Best answer by ebygomm 9 April 2020, 11:41

View original

7 replies

Badge +2

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

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 :)

Badge +21

@ninani,

 

 

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

 

 

Input

 

 

Output

 

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!!!

 

 

Userlevel 2
Badge +21

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

delete values python.fmw

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!!!

Badge

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

Reply