Forum Discussion
Pivoting multiple files into one
FredPereira See attached, I have created 2 sample tables file1 and file2, look at file1 which is pivoted. Key here is to add unique identifier for each table before pivot. I added index column in both files which work as unique identifier, you can call that index column anything, with any value but it need to be unique for each file.
FredPereira See attached, I have created 2 sample tables file1 and file2, look at file1 which is pivoted. Key here is to add unique identifier for each table before pivot. I added index column in both files which work as unique identifier, you can call that index column anything, with any value but it need to be unique for each file.
Forgot to mention an important detail.
I am linked to a folder, so I am merging all the files that way. So everyday, around 50 files are downloaded and inserted in said folder everyday.
The idea is to have my database updating automatically just by adding files to the folder.
Will the index column be feasible in this scenario?
Thank you very much for the response!
FredPereira yes it is even better, basically the way you want to think is to have a column with unique value in it for each file, in case of folder, you can surely have filename as unique or create one. I think it is easier and solution I provided would work.