![]() In the Original data type group, choose the Fixed width option: Note: If you see delimiters, leave the option. In the Text Import Wizard Step 1 of 3 dialog box: 4.1. ![]() Why it can be like that? Why Power Query choses to use Table.FromColumns instead of Csv. On the Open dialog box: Select the path to the text file you want to import, From the File Type dropdown list, select All Files or Text Files: Click the Open button. ![]() = Csv.Document(File.Contents("C:\Users\MyUserName\Desktop\123.txt"),) No delimiter selection Wrong Source Code Proper code that I would like to have PQ inserted automaticallyĪnd after importing the source code looks like that: I am trying to import Text/CSV file in Power Query, but while doing that I don't have an option to chose delimiter in the import window as it is shown in the following post response:Īnd there is only one column which I can't split into several columns as there is no delimiter choose option:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |