Skip to main content
  • EN

Hello Everyone,

 

I have a question how to copy row data, but cant seem to find an efficient way to do it yet.

 

Below, attached is a Screenshot of the Original Excel file.

The idea is to take a cell value (in this case the 0.10 in the blue field at the top) and copy it for all empty column values until it reached the next filled value (0.20), which will then be copied downwards in the column.

 

 

So your result will look like this.

 

I assume with something like:

 

If CellValue Col x Value is Empty

Then Copy Col x - 1 Value to Col X

 

Continue to Col x + 1 and loop

 

Something along those lines.

Has someone dealt with this before?

 

Cheers

Fred

Hi @freddy17

Could you share us a dataset?

 

Thanks in Advance,

Danilo

No, looping required, just adjacent attribute handling in an attributecreator with a conditional statement which basically says, if ColumnA has a value keep the value as ColumnA, if there is no value, use the value ColumnA from the feature above. Because FME processes the features in order, the value above is always completed ready for the next line

No, looping required, just adjacent attribute handling in an attributecreator with a conditional statement which basically says, if ColumnA has a value keep the value as ColumnA, if there is no value, use the value ColumnA from the feature above. Because FME processes the features in order, the value above is always completed ready for the next line

Hi ebygomm,

Thank you for pointing this out, is a great time saver.

 

@danilo_fme, I have added my excel and the FME solution to my enquiry, works exactly how I would want it.

 

Regards

Fredcopyrowvalues.xlsxcopyrowvalues.fmw

Reply


Community Stats

30,114
Posts
114,307
Replies
37,746
Members
Terms & ConditionsCookie 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.