Craigc3814
Board Regular
- Joined
- Mar 7, 2016
- Messages
- 217
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.
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.