I want to merge multiple fields from multiple lookup tables into a single field/column. I only know the name of the field in table1.csv and not the name of the field in the appended table. Unfortunately, the below does not work as rename will not take * by itself. I have no idea what the field name will be in the appended table, though, I will know the table name.
| inputlookup table1.csv
| append [| inputlookup table2.csv | rename * as name]
If table1.csv and table2.csv have the exact field names, then the below works, but that won't be the case in my situation. In my situation, doing so will create two columns and not one merged column.
| inputlookup table1.csv
| append [| inputlookup table2.csv]
... View more