I have a csv file with a column with values A1,B1 C1, A2,B2,C2,A3,B3,C3.
In another csv file there are 100 rows with data in 4 columns.
Now I like to add the data from the first csv column to column 5 of the big csv file. But this column 5 should be filled with as many times the data A1,B1 C1, A2,B2,C2,A3,B3,C3 until there is data in column 5 of all 100 rows
I have added 3 csv files. One (File2_wellid.xlsx with 9 rows to add, one file (File1_picking.xlsx) with 100 rows and one file (File3_result.xlsx) what the result should be.
It’s possible, see chunkloop_2.knwf (36.7 KB) with the Extract Table Dimension node you collect the number of rows and transport them via a flow variable to your Chunk Loop Start