Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QGurus – In the attached qvw, we can see the raw data and equivalent representation in pivot table. However, my customer is expecting output in one of the following format. Any guidance on how we might achieve it without having to modifying the raw data? Many thanks!
Expected Output
Raw Data
LastName | FirstName | Parents | Child |
Morgan | Debra | Doris | Nicholas |
Morgan | Debra | Harry | Nicholas |
Morgan | Dexter | Harry | Astor |
Morgan | Dexter | Harry | Cody |
Morgan | Dexter | Harry | Harrison |
Morgan | Dexter | Laura | Astor |
Morgan | Dexter | Laura | Cody |
Morgan | Dexter | Laura | Harrison |
Pivot Table We're Looking to Modify
I dont believe this is feasible
Thank you for your input @Ramon!
Any other guidance Qlik Gurus?