Skip to main content

Howdy! I have some Task Order and Sub Task Order data which is like contract data. I am trying to show the Sub Task Supervisor for each Sub Task. The problem is that in the original data there is more than one ID in the field, sometimes. I can pivot the data to show just one ID which is fine but it reduces the level of detail for my view and I working with financial data in my real data which is exploding my values after joining.

 

What I would like is to join the data re-pivot the data to show the names like this: Harry|Suzie|Joe. This is fine as I would only show this value via a tool tip.

 

I have included some raw data:

  1. Task Order Sub Task Order Data is the basic table.
  2. Sub Task Order Supervisor contains the names. It joins to the Task Order Sub Task Order Data via the Sub Task Supervisor List
  3. Final View I am looking for is an example of what I am looking for.

 

What I am getting right is something that looks like One Hot Encoding and that's not the result that I am looking for.

 

Thanks,

 

Scott

3 risposte
  1. 8 lug 2021, 01:46

    Hello @Scott Carman​ ,

    See the attached flow. The trick is to aggregate the rows back up after you pivot and join.

    @Robert Breen​