Hey,
I have about 10 Excel sheets which should be a big one. Every Sheet has the same X colums with same data first (Light blue), then Y colums with specific colums and data (blue, orange, green) and a ID which should be the same in every sheet.
Based on the node description (haven’t used it myself), I would imagine that the Column Appender node would be appropriate in this situation. Also, the default behavior of the looping function is to append rows, but maybe you should instead try the Loop End (Column Append) node – this appends the columns together in a loop rather than the rows… Just a few suggestions to try for now. I’ll try to provide an example for you later today.
I used a Rule Engine Variable node that helps to add only the green and orange columns . There is one thing I have some concerns about. Does every files has the same number of records? With the same ID’s in the same order? If not you need a different solution.
Hope this helps.
Hey,
at first - thank you! - works!
Now I have to understand the magic
And yes - same number of records with same ID in same order. Of course it would be better if the ID would be used to map the colums, but first of all it works for me - thank you very much!