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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 09, 2024

Agree with Lorenzo , without sample file it's hard to help. In general functionality works as expected, at least on Excel desktop for Windows.

  • 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

     

Resources