Forum Discussion

iam6ft7in's avatar
iam6ft7in
Copper Contributor
Nov 08, 2024

Importing CSV Data, Detection of Structure Inconsistent

I use the data import feature of Excel a lot at work and occasionally at home.  When I do I use the PQE (Power Query Editor) by pressing the Transform Data button. I've run into a situation where I ...
excel
iam6ft7in's avatar
iam6ft7in
Copper Contributor
Nov 15, 2024

Please find attached a file that is formatted exactly as both of the other files where one works and the other does not.  Besides the differences in terms of the transaction data, the only difference between the two files is on the second line of each file.

 

File One

DateRange: 11/01/2021 - 11/08/2024
Account Type: Card Account
Date Timestamp - EST,Description,Amount

 

File Two

DateRange: 11/01/2021 - 11/08/2024
Account Type: Deposit Account
Date Timestamp - EST,Description,Amount

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 15, 2024

Thank you, but I can't reproduce you problem on file provided

 

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 30, 2024

      iam6ft7in , thank you for the file. As workaround in formula bar you may change Delimiter on comma and Columns on 3

      Didn't catch why PQ doesn't recognize that automatically. 

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Nov 17, 2024

    Can't repro either with 365

     

Resources