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|
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
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?
Solved! Go to Solution.