Forum Discussion
Merge files keeping additional created columns
Hi!
I'm racking my brain over something I thought would be simple. These are all the files I have inside a sharepoint folder(they all have the same structure, only the row values change):
In this initial step of my PowerQuery, I needed to create two new columns:
- "FileDate" column (coming from the column "Name").
- "Year.Quarter" column (based on the "FileDate" column).
This two columns allows me to filter only the files I need to merge to create a single table. However, when I click the merge files icon in the "Content" column (marked in red in the image), PowerBI merges only the rows of the files I need, but without the "FileDate" and "Year.Quarter" columns I created earlier. Not even the "Name" column, with the origin file names, appears. If it were present in these merged tables, I could create "FileDate" and "Year.Quarter" columns again, but it doesn't appear, and I can't tell which file each row in my merged table belongs to.
How can I create a merge of the tables that maintains the "FileDate" and "Year.Quarter" columns I needed to create in the steps prior to this merge?
nok In your Applied Steps area, look for a Removed Other Columns step. Click the gear icon and select the other columns that you want to include and not be removed.
1 Reply
nok In your Applied Steps area, look for a Removed Other Columns step. Click the gear icon and select the other columns that you want to include and not be removed.