Solved
Unpivot Data From a File Load Activity
Hi All -
I am creating a workflow that I hope will be able to map one file layout to another. I am making plenty of progress, but I have hit one sticking point.
The inbound data format is something like:
| Person ID | Favorite Food | Favorite Color | Favorite Drink |
| A | Chicken | Red | Water |
| B | Veggies | Blue | Soda |
Ideally, I would like to be able to emulate the "Unpivot Columns" function in Excel Power Query to un-pivot the data so it reads more like
| Person ID | Attribute | Value |
| A | Favorite Food | Chicken |
| A | Favorite Color | Red |
| A | Favorite Drink | Water |
| B | Favorite Food | Veggies |
| B | Favorite Color | Blue |
| B | Favorite Drink | Soda |
If this data were already in the Adobe DB in separate tables (ex. individual, individual-surveys, and surveys), I could use an enrichment activity with a one-to-many link between the tables to load out the rows.
However, I am curious if this is something that could be done with an activity entirely within a workflow.
Anyone have any good tricks for this?
Thanks