Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Double Counting Help - Debug Query

  HI Team   Can you please help me debug based on steps below?   as you can see Power query mysterioulsy creates another duplicate table "April 2021" , although i have just ONE excel file by tha...
Need Help
Show and Tell
AlexisOlson's avatar
AlexisOlson
Super User
5 years ago

The April workbook probably contains multiple tables. Try expanding the Name column too and you should see the names of both tables.

 

Table.ExpandTableColumn(#"Added Custom", "Custom", {"Name", "Data"}, {"Name", "Data"})
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    No there no additional tables

     

    All files have same schema

     

    I just tested,

     

    if I just open any of files below and simply save again,

    power query creates another table

     

    I was thinking temp files, but I cant see any  except the hidden desktop "file"

     

     

    • AlexisOlson's avatar
      AlexisOlson
      Super User
      5 years ago

      Can you show what the result looks like if you expand all of the columns of your custom column (Name, Data, Item, Kind, Hidden) in the query editor?