Discover the winners & finalists of the 2022 Dataiku Frontrunner Awards!READ THEIR USE CASES

Pivot/transpose - Help Required

RachitKumar
Level 1
Pivot/transpose - Help Required

Hi Team,

Can anyone please help me how we can achieve the below:

Input :

PartyAAA
NameA2A
ID100
  
  
  
PartyBBB
NameA2B
 ID101
  
  
PartyCCC
NameA2C
ID102

 

Expected O/P -

PartyNameID
AAAA2A S.P.A.100
BBBA2A S.P.F101
CCCA2A S.P.F102
0 Kudos
1 Reply
RachitKumar
Level 1
Author

I tried doing Pivot it will give me one record using MIN,MAX etc. but I need all the records.

0 Kudos