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,
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
Solved! Go to Solution.
Hi @Masond3
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍