Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Just started with power query, I have an excel template that I use which gives me the data I need with the columns set up, however on a monthly basis the csv file that comes through, has the data set in different columns, this is just how it comes in, is there any way of being able to set this up so that a column looks up the whole data set from the csv file and pulls through the correct column.
eg...
My template is setup like this
First Name | Surname | Age | Gift Amount |
Test | One | 25 | 20 |
Test | Two | 36 | 20 |
Test | Three | 41 | 10 |
Test | Four | 28 | 15 |
Each month the data could come in as:
Surname | Gift Amount | First Name | Age |
One | 20 | Test | 25 |
Two | 20 | Test | 36 |
Three | 10 | Test | 41 |
Four | 15 | Test | 28 |
or
Gift Amount | Surname | Age | First Name |
20 | One | 25 | Test |
20 | Two | 36 | Test |
10 | Three | 41 | Test |
15 | Four | 28 | Test |
Is there a way of being able to set up within the data model a way of it automatically looking up the correct column and pulling it through?
Thanks
Solved! Go to Solution.
Hi @UK_User123456 ,
If you get data from folder, then your data will be append automatically by column name.
Hi @UK_User123456 ,
If you get data from folder, then your data will be append automatically by column name.
The order really shouldn't matter as long as the csv isn't adding in more columns from month to month that moves the columns you want out of the field of view?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |