Forum Discussion
Expanding column after left join shuffles values in single column
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]}})
Hi Ibendin, thanks for your response. How do I fix this?
Super UserInclude the event time in the composite key or use index columns.
Now I see what you mean with composite key. I already use a composite key with an index, the event time wont work, because the two events that I want to link never occur at the same time. Alos, I believe match on the composite key isnt the problem here, as the matching works fine (see the example), the problem occurs upon expanding the values from the matched records.
camargos88Community Champion
Hi Anonymous ,
Is it possible to take a look at your pbix file ?
Yes, sure. How can I share this? Also taking into account the confidentiality of my data sources