Skip to main content
  • EN

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

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.

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.

thankyou @nielsgerrits​ for your quick response and workaround

Reply


Community Stats

30,114
Posts
114,307
Replies
37,747
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.