Hello, I need a query against a file that will have changing amount of columns...and changing columns headers names!
My query will require this columns to work: InD - Client - USD
Source File 1 columns: Date - Customer - Amount - Taxes
Source File 2 columns: Sales - Name - Received - Others 1 - Ship
I will have an equivalences table like this, so my query headers will have their equivalence:
Ind - Client - USD (Power Query headers)
Date - Customer - Amount (Source File 1)
Received - Name - Sales (Source File 2)
I will load 1 source file at a time (I do not need to consolidate)
Sometimes I will load only Source File 1
Sometimes I will load only Source File 2
Is there any way Power Query can get the data using the equivalences table?
Thanks for your help!
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 5 guests