Skip to main content
Solved

How to store data in FME Workbench itself ?


vimva679
Supporter
Forum|alt.badge.img+9

Hello All,

 

Please have you got an idea how i could store more then 100+ records ? When i run the WB it should compare or find the value and do the needful.

image 

image 

thank you all

Best answer by nielsgerrits

nielsgerrits wrote:

Some Python trick is probably more efficient, but when I need this I copy paste the Excel cells to one attribute, then use the AttributeSplitter and ListExploder to split it to rows, then the AttributeSplitter and AttributeCreator to split and create the columns.

Added workspace demonstrating this.

View original
Did this help you find an answer to your question?

3 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

Some Python trick is probably more efficient, but when I need this I copy paste the Excel cells to one attribute, then use the AttributeSplitter and ListExploder to split it to rows, then the AttributeSplitter and AttributeCreator to split and create the columns.


nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • June 23, 2023
nielsgerrits wrote:

Some Python trick is probably more efficient, but when I need this I copy paste the Excel cells to one attribute, then use the AttributeSplitter and ListExploder to split it to rows, then the AttributeSplitter and AttributeCreator to split and create the columns.

Added workspace demonstrating this.


vimva679
Supporter
Forum|alt.badge.img+9
  • Author
  • Supporter
  • June 23, 2023

thankyou @nielsgerrits​ for your quick response and workaround


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