Forum Discussion
Fixed Width Import Issue
Thanks.
This is the first line of what the raw ASCII data looks like: it's not properly delimited and has no headers:
A 0 201301 99993GU 999922 2 34105JA GU 999 9 1107 4 08 X1 3 32 0507 4 086 00 1 1 031 1509 253 N00000000 N NNNNNNN NXXN00 2 222 NN NNNNNNN 2 2 NNNNN NNNNNN 2 2 2 11X 221 1NNNNNN1N22 104885 1 M 03 201240 40082 3317093 NNNNNNN NNNNNNNNNNNN22 2 2 2 2 UYU 2888888888888888111136619 11111111111111111111 1111111 111111111111 111111 1111111111111111111111111111 1 11 1 111111 11 1 111 1 1 1 11 11 1 1 1
This is the full data dictionary, listing all the positions of the variables delimiting the ASCII file above:
https://docs.google.com/spreadsheets/d/1Y4YiryitBV9fuNdnwk8ko5k-6HYqP6G7ClhsnAQC5FU/edit?usp=sharing
If I show the imported data into PowerBI, it hides the issues because I cannot add all the variables due to overlapping positions, let me know how I should show you this
I don't understand what that data is. It's delimited and it doesn't seem to match the data dictionary at all.
Maybe you can link some sample data in original form with rows that exhibit the problem. I need to see enough rows that show the problem.
----
If you can post the sample data then take a screenshot of what powerbi does when you import the same file. You can describe it or annotate it to describe the problem and show me the desired result.