2 newbie Power Query questions

[Craigc3814]

I am very new to Power Query so I apologize if this is a very easy or "dumb" question. I have a folder that contains .txt files for a monthly bill my company receives. Every month I want to be able to drop the new .txt file in the folder and refresh the query (I am good so far). The problem is the .txt files do not have a header so every time I refresh I have to paste the headers back in. Is there a way to make the header row unchanged when refreshing the query? Or any options available so that I do not have to keep pasting in the headers?


2nd question: There are unique id's in a column on the imported data. I want to make a second table that essentially "decodes" the unique ids and converts them to what the unique ids really are in text format. An example would be a unique ID of 5465465454, this is just a number the billing company assigns a given building in our operation. So when I see 5465465454 I want that to look at the table I make and return the text value that, that number really represents so maybe I need a helper column that runs a vlookup, or index match. Not sure.

 

[Matt Allington]

First q
1. Load the headers and set them to "only create connection"
2. Follow my pattern to create a single table of all your data (Combine CSV Files with Power Query - Excelerator BI). Also set to create connection only.
3. Append the header then the combined table in step 2

point 2? Not sure what you mean

 

[Comfy]

Q.2

Import your lookup table into PQ and choose connection only.
Then use "Merge Queries" using the ID as the match criteria, you can then choose which columns from your lookup table you wish to show.

https://support.office.com/en-gb/ar...7ca2616d17f9?ui=en-US&rs=en-GB&ad=GB&fromAR=1