Forum Discussion
Combining Files with Dynamic Date Columns in Query Editor
Hi Anonymous,
Import the folder and adapt the Transform File function accordingly.
mwegener Thank you very much for your help!
My takeaway from this is that you can essentially "unpivot other columns" on all of the files before the combining of them takes place.
Would you mind commenting more on this process other than the two screenshots or posting a link that can provide more guidance? The dataset I am working with is much more complicated than my example tables so I would just this solution to be scalable.
I really appreciate any help! Thank you very much!!
Hi Anonymous ,
what can I write about it?
1. I imported the files from "Folder" using "Get Data".
2. I used the "Combine & Transform Data" option.
3. Then I modeled my transformation using the "Transform Sample File" query.
3. Then I copied the transformation into the "Tranform File" function using the "Advanced Editor".
Make sure that the transformation steps are valid for all files.
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.