POWER QUERY AND .DIF (EXCHANGE FILES)

[lwarren1968]

I'm attempting to initiate a combine power query from a folder with several .DIF files. Each file should have the same layout with 3 columns of data. That being said when attempting to combined all the data pulls into one column. I'm new to this, so I'm not sure what it is i'm doing wrong. Please help as this is going to have to be an ongoing process for database updating purposes.

 

[Isaac]

I don't know what a ".dif" file is, but maybe the file is delimited in some way that you have'nt properly specified to the app (power query) which is trying to read it in.

When in doubt, try opening the file in Notepad++ and see what the delimiter appears to be

 

[lwarren1968]

its a ASCII text

 

[Isaac]

But I'm referring to the method of delimiting.

 

[lwarren1968]

TABLE
0,1
"BIN"
VECTORS
0,4.000000
""
TUPLES
0,0000055
""
DATA
0,0
""
-1,0
BOT
1,0
"00885532555"
1,0
"001"
1,0
"09A01"
1,0
"OUT RC CONVERTER KIT"
-1,0
BOT
1,0