Forum Discussion
Column Matches
Hi,
I would like to learn wherher there is a solution; there are two or more different reports which have similar data but under different column names such one report contains Date, Customer Name, Product And Quantity, ... Other report has the same data but under different column names and different places on the table such as Musteri Adi (Customer Name), Tarih (Date), Miktar (Quantity), Urun (Product) ... How can I match the columns while appending the reports?
Best Regards,
Hi HasanK
Sure, its because I forgot to mention a rather imported thing, the function is using one of the columns in the columns mapping table, to fix the error you can rename the column names or adjust the function.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
6 Replies
Hi HasanK
Please see the attached with a solution, it can be set as per below.
You can create an extra table with all the possible column names and translations, in the attached example table name is columnsMapping.
Create a function that will check names in the given file against your mapping table and rename the column accordingly, in my example the function name is renameColumns and it's applied as a step in the data table, but if you work with folders that could be adjusted to a column and invoked as "Invoke Custom Function" that way you could expand all columns together without extra step to append.
let me know if anything isn't clear.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
