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
Solved! Go to Solution.
Views
Replies
Total Likes
Hello @roberts60640699
There is no Out of the box functionality to do the mentioned. But you can run any SQL query you want by JSAPI sqlExec() where you can "unpivot"
Marcel
Views
Replies
Total Likes
Hello @roberts60640699
There is no Out of the box functionality to do the mentioned. But you can run any SQL query you want by JSAPI sqlExec() where you can "unpivot"
Marcel
Views
Replies
Total Likes