Forum Discussion
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". ...
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]}})
v-eachen-msft
Community Support
Community SupportHi Anonymous ,
Try to change the order of "Changed Type" and "Expanded UnitOperationEnd".
I have removed the change type step, but I dont see how this changes anything. Also swapping the two steps doesnt change anything.