Skip to main content
Solved

How to store data in FME Workbench itself ?

  • June 23, 2023
  • 3 replies
  • 61 views

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

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

nielsgerrits
VIP
Forum|alt.badge.img+60
  • 2937 replies
  • June 23, 2023

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+60
  • 2937 replies
  • Best Answer
  • June 23, 2023

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
  • 96 replies
  • June 23, 2023

thankyou @nielsgerrits​ for your quick response and workaround