I have data that with columns: ID, Category, V1, V2, V3, ..., VN
N is unknown in advance - it is specific to the data.
Category has an unknown M number of levels - it is specific to the data.
I want to reshape that data to get columns: ID, Category1V1, Category1V2, ...., Category1VN, Category2V1, Category2V2, ....., CategoryMVN
If I knew N and M in advance then I could manually set up the work flow using filtering and joins, but I don't know N and M in advance. I need the work flow to react dynamically to the structure of the data.
I can do this using looping in R but I want to do it natively in Alteryx. Is there a way to do this?
Colin
