POWER QUERY AND .DIF (EXCHANGE FILES) (1 Viewer)

lwarren1968

Registered User.
Local time
Today, 10:08
Joined
Jan 18, 2013
Messages
51
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.

1609774744585.png
1609774798603.png
1609774911446.png
 

Attachments

  • 1609774874974.png
    1609774874974.png
    24.8 KB · Views: 31
  • 1609774902533.png
    1609774902533.png
    38 KB · Views: 30

Isaac

Lifelong Learner
Local time
Today, 10:08
Joined
Mar 14, 2017
Messages
5,386
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

Registered User.
Local time
Today, 10:08
Joined
Jan 18, 2013
Messages
51
its a ASCII text
 

Isaac

Lifelong Learner
Local time
Today, 10:08
Joined
Mar 14, 2017
Messages
5,386
But I'm referring to the method of delimiting.
 

lwarren1968

Registered User.
Local time
Today, 10:08
Joined
Jan 18, 2013
Messages
51
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
 

Users who are viewing this thread

Top Bottom