Afternoon Alteryx Community
Hope you can help me or put me in the right direction
Version : Alteryx Designer 20019. 19.3 X64
I have an CSV input file, that has following 4 column headers;
| Instance Id | Question Id | Question | Answer |
First Step,
- Order by Instance Id
- Order by Question id
From here i am only Interested in a particular set of questions id.
The question ids i am interested in are
| Question Id | Question |
| 3 | Billing Address Line 1 |
| 4 | Billing Address Line 2 |
| 5 | Billing Address Line 3 |
| 6 | Billing Address City |
| 7 | Billing Address Country |
| 8 | Billing Address State/County/Province |
| 9 | Billing Address Postal Code |
| 548 | Billing Name |
For these static questions id, i would Like to create these Question as a header on a new excel tab.
Example header Output
| Instance Id | Billing Address Line 1 | Billing Address Line 2 | Billing Address Line 3 | Billing Address City | Billing Address Country | Billing Address State/County/Province | Billing Address Postal Code | Billing Name |
For a given Instance Id i would like the corresponding answer for the questions above to map back to the relevant header
Dummy Data
| Instance Id | Question Id | Question | Answer |
| 11111 | 3 | Billing Address Line 1 | 123 High Street |
| 11111 | 4 | Billing Address Line 2 | |
| 11111 | 5 | Billing Address Line 3 | |
| 11111 | 6 | Billing Address City | London |
| 11111 | 7 | Billing Address Country | UK |
| 11111 | 8 | Billing Address State/County/Province | London |
| 11111 | 548 | Billing Name | VodaPhone PLC |
| 11111 | 9 | Billing Address Postal Code | EC1 1AA |
Expected Outcome
| Instance Id | Billing Address Line 1 | Billing Address Line 2 | Billing Address Line 3 | Billing Address City | Billing Address Country | Billing Address State/County/Province | Billing Address Postal Code | Billing Name |
| 11111 | 123 High Street | | | London | UK | London | EC1 1AA | VodaPhone PLC |
Looking forward to your Help
