Hi Team,
I am new to the alteryx world. I am stuck with a problem , it would be really great if you can provide some pointers on this.
I need to create a work flow to get data in a particular format. Below is the requirement.
1)Check the column Product 1, Product 2, Product 3. . . for each row . If the value under the column is Y, then add a new row with the same details as the active row (in this case row 1) for the first three columns(i.e country, city, code in the sample data provided) .Create a new column in the output and copy the heading of the column for which the value is "Y" into the newly added column(In this case "Products"). Continue this process for all the columns in row 1 until there are no more columns. Repeat the whole process for all the rows in the sheet . Sample data of how the output has to look is shown in table 2.
Actual Data
| country | City | code | Product 1 | product 2 | Product 3 |
| China | Beijing | A123 | Y | N | Y |
| India | Bangalore | B123 | N | Y | N |
| Australia | Sydney | C123 | Y | Y | Y |
final data should like below.
| country | City | code | Products |
| China | Beijing | A123 | Product 1 |
| China | Beijing | A123 | Product 3 |
| India | Bangalore | B123 | Product 2 |
| India | Bangalore | B123 | Product 3 |
| Australia | Sydney | C123 | Product 1 |
| Australia | Sydney | C123 | Product 2 |
| Australia | Sydney | C123 | Product 3 |
Thank you in advance.
