Get data from file with changing columns and names

rolo
Posts: 16
Joined: Tue Sep 27, 2016 8:14 am

Get data from file with changing columns and names

Postby rolo » Sat Nov 23, 2019 8:35 am

Hello, I need a query against a file that will have changing amount of columns...and changing columns headers names!

For example:

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!

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 0 guests

cron