Hello! Please help to solve the problem. It is necessary to fold four tables using a joiner. The key column is the title, the values of the variables are minimal. I attach a classic solution. Since it is supposed to add about three hundred tables, you need to implement a solution using simple or recursive cycles. Thank you.
T1.xlsx (9.6 KB)
T2.xlsx (9.7 KB)
T3.xlsx (9.9 KB)
T4.xlsx (9.3 KB)
result
T_all.xlsx (7.2 KB)
Workflow
Data_join_table_result.knwf (135.2 KB)
Hi @st1980ur , I took a look at your sample output xlsx.
That was from joining 4 tables. So if in your anticipated real flow you have 300 tables, do you really want final column names to be like this? :
Min(D) (right) (right) (right) (right) (right) (right) (right) (right) (right) (right) (right) (right) (right) (right) (right) (right) (right) (right) (right)... *repeat 300 times* ... (right) (right) (right) (right) (right) (right)
Hello! Do you know any alternative solutions?
Hi @st1980ur
Can you please check my alternative approach using the ‘Table Row to Variable Loop’ method? This allows you to dynamically process any number of tables without manually chaining multiple Joiner nodes. I believe this version scales better, especially when working with hundreds of files.
Best,
Alpay
Data_join_table_result_AZ.knwf (67.0 KB)
1 Like
Your example workflow would be more helpful if you included the data.
1 Like
Hi @rfeigel,
I used the exact tables that @st1980ur shared in the original post, so I didn’t want to repost them here to avoid redundancy.
Best
Alpay
@st1980ur I was asking because I was wondering what solution you really wanted, as whilst multiple joiners would create your example, it felt impractical to deal with those kind of column names. Often the choice of eventual solution would be dependent on your requirements.
But I think @alpayzeybek 's solution looks very neat, and using the iteration number as part of the column identifier by pivoting on it is a good idea!
1 Like