Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Expanding column after left join shuffles values in single column

Hi all,    I cant figure out what is going on in the case below. Hope somebody can tell me what I might be doing wrong.    So I merged two tables based on the columns "UOKey" and "RepetitionNr". ...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    I just got an ideia...

     

    How about if you Group, Sort and add the index column (those 2 last inside the [Data] column instead of sort / group / index ?

     

    Like:

     

    #"Grouped Rows" = Table.Group(#"Sorted Rows", {"UnitOperationKey"}, {{"Data", each Table.AddIndexColumn(Table.Sort(_,{"StartTime"} ), "SequenceNr", 1,1), type table [UnitOperationKey=text, NoOfRepetitionsOfUO=number, StartTime=datetime, BatchID=text, Unit=text, Label=text, UnitOperation=text, SequenceNr=number]}})

     

     

     

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous ,

 

Once it's a Power Query situation, please provide a file or import it as inputed values, so we can import it. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I  know this post is almost two years old, but I wanted to report that I had the same issue. 

 

If I filtered the data to get a smaller subset, I didn't have the issue of my original values getting mixed together (not just resorted, but mixed up), but with the full data set, it was a problem. 

 

I resolved it by expanding and choosing to aggregate the field I wanted, and it worked. This definitely seems like a bug. I am using proprietary data so can't provide an example, but I wanted to report that this does appear to be a bug. 

 

Is this on the development team's radar as a bug?