Hi Community,
I am still new to Alteryx and many of its features. My current requirement is such that I have a key of Response ID and Question ID and another dataset wherein I have column headers with the Question ID attached with some Sub-Question ID ex. 108_#Q65_1_1. They are arranged according to the Response ID. A snippet of that is as follows:
Key:
| ResponseId | ID2 |
| R_3oNklJ0xzVqTu6y | 198 |
Dataset:
| ResponseId | 108_Q29#1_1_1 |
| R_10pyjpbpaiKuIAe | Close the 2 Austrian Business Units and have Bonn and Berlin takeover their customers |
The dataset contains many such columns with multiple Question ID. Is there a way that I can get the data in the following way wherein I get the Columns according to the SubQuestion ID and the rows according to the Question ID and Response ID?
| ResponseId | ID2 | Q29_1_1_1 |
| R_10pyjpbpaiKuIAe | 108 | Close the 2 Austrian Business Units and have Bonn and Berlin takeover their customers |
| R_2wBOCXdJ5lPklDk | 198 | Integrate the relocating Austrian employees with the existing Bonn business unit employees |
Also is it possible to make it a loop as the size of the key is not fixed?
Any help is appreciated and I have attached a mock data sheet with the dataset and key as well.
Thanks.
