Forum Discussion
Fixed Width Import Issue
Hi all, I'm kind of a beginner in PowerBI, but I have a pretty large ASCII dataset that I'm trying to delimit into proper columns. For each variable, I have the text position mapping in order t...
I'm not seeing any further clarification. Powerbi won't let you use this
6,7,14,18,20,28,28,29,31,36,39
so you have to use something that'll get your data into power query and worry about the correct columns once it's in there.
What happens when you use this?
6,7,14,18,20,28,29,31,36,39
That series of numbers works, but then I'm excluding a ton of variables that have some position overlaps with other variables, which I'm not sure how to fix after I import
What would you recommend for me to add those variables after import, if I know the exact positions of them in the ASCII file?
