Good day Mynda,
When I try to import a .txt file into PQ, I do not get the options to select the delimiters/ columns I need, it imports everything into one column.
In the tutorial the practice file imports as a 1200: Unicode where you have the option of selecting the delimiters. However when I import my .txt file I don't get the options of delimiters. It imports everything into one column only with no options of setting what the delimiters are.
It also imports the file source as a 1252: Western European (Windows) file, a also doesn't give me delimiter options, even if I change the file origin.
How do I resolve this issue as this is weekly source data that I would like to apply some of the variable and parameters on, in order to ultimately save time.
Thank you
Hi Charmaine,
It sounds like you have an out of date version of Power Query. Can you ask your IT people to update it?
In the meantime, if you look at the 'source' step in the query editor you'll see the parameters for source origin and delimiter and you can edit them directly in the formula bar.
Mynda
Hi Mynda,
Thank you I will do.
I see that the "instruction" in the formula bar is different to the tutorial. I have attached a screen shot.
We are trying to import a General Ledger Trial Balance Report into PQ. Would the fact that there is "General Text" in the document be an issue?
I will get IT to check the update for me, thank you.
Thank you
Charmaine
Hi Mynda,
When I tried the pq.2_04 exercise it comes up exactly as per the tutorial, giving the deliminator options etc.
Is there prepares an issue with the way the .txt document is being saved?
Thanks
Charmaine
Hi Charmaine,
There wasn't a screenshot attached with your previous comment.
It's possible that your .txt document isn't being saved in a proper delimited format. Some software programs create a .txt or .csv file but they don't do it correctly. It's like taking data created in Word and then just changing the file extension to .txt. It might appear to be a .txt file, but it's not really.
That's not to say you can't parse the data using power Query. It just needs consistent identifiers that will allow you to separate the data into columns.
Mynda
