i have information table1 like below
Colomn\\RowABCD1SNSFruitCOSTQuantity21Apple20per Peace32Banana3per Peace43Orange8per Peace54Mango50Per KG65Cherry250Per KG76Papaya40Per KG87Graps80Per KG98Dragon200Per KG109Kiwi30per Peace1110CustedApple60Per KG1211Fine Apple40per Peace1312Green Apple25per Peace
and having another table2
Colomn\\RowAB1Fruitapple2Price
i need write value at table2 Cell position B2 with 20 from table 1
Hi @rakeshreddy0996
There is a insteresting Webinar about Excel files in FME: https://www.safe.com/webinars/tips-automating-excel-data-processing-tasks-fme/
In the feature type on Writer you can set the position:
Thanks in Advance,
Danilo
Just to answer the subject, if you use a FeatureWriter to insert into an excel file you can specify the Start Column and Start Row to make your "20" plop down in B2. That's an easy way to do it if your excel file already exists with the desired layout and your workspace is outputting the "20".
Hopefully this workflow could help you. The NumToAlphaConver is a custom transformer from FME Hub, which converts 1 to 'A', 2 to 'B' ... and so on.
Just to answer the subject, if you use a FeatureWriter to insert into an excel file you can specify the Start Column and Start Row to make your "20" plop down in B2. That's an easy way to do it if your excel file already exists with the desired layout and your workspace is outputting the "20".
could please brief
Thanks
Rakesh reddy