I have number of data files, lets assume 25 number of them stored in a specific location. Now I want to merge everything in a single master table.
But the catch is the columns have different names with months and the files will be stored every month. I want to change the cloumn name from November-11 Current to 'Month Current' and November-11 Savings to 'Month Savings' for all the files shared till date and going to be in future. Do you have any smart solution to it?
Hi @Redzapplin , you can keep all the files into same folder and follow this config. Assign your own path on connect a file or db field. If your files have same schema as given then this will work and then you can use select tool to rename the current and saving tab.
Please mark this post as solution, if it helps.
Thanks.
