Skip to main content
  • EN

FME workbech

workbenchREADER (raw excel file)

Raw excel file 

TRANSFORMER

counter setting 

WRITER ( Desired or Expected RESULTS) SETTING

1st row is merged

2nd row id columns names

I want the data to be inserted / updated from ROW 3 keeping the first 2 rows same.

 

Note : Everytime i run FME the number of ROW records will change so results should dynamicaly upated and NO APPEND .

DESIRED output 

WRITER SETTINGS

writer setting 

TEMPALTE : Template

If shall be highly thankful to your help or support :)

Hi, how to use formula finde?

@magi​  Have a look at the example on this question

thank you all for ur help and quick support :)

Reply


Community Stats

30,166
Posts
114,517
Replies
37,821
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.