Forum Discussion
How to associate specific columns with dates when loading data?
Hi, I have a list of excel files. Each of them contains the following data.
- Questions
- dd.mm.yyyy
- Customer name
- Answer
- Comment
Questions are the same, but columns "Customer name", "Answer" and "Comment" are repeated, and they are related to the dd.mm.yyyy column.
All I want is to associate columns "Customer name", "Answer" and "Comment" with the dd.mm.yyyy columns. Right now I just have columns dd.mm.yyyy_1, customer name_1, ....
As a result, I want to remain only 3 columns, that are associated with the different dates.
Sorry if it is not understandable. I would be grateful if you could give me some direction.
2 Replies
Hi,
I hope you are using Folder as a data source where you are pointing the folder path.
In a easy way, maintain the name of the column is same acorss all the files.
Ref - https://sqlitybi.com/loading-multiple-excel-files-from-a-folder-in-power-bi/
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My LinkedinThanks for your response. Yes, I'm using folders as a source.
I have lots of excel files, but the structure inside is the same. It looks like that:
But I want to gather all that data and create beautiful graphs in PowerBi. But I'm stuck with associating specific answers to specific dates..
