Hi All,
I'm pretty new to Alteryx!
I used transpose tool to convert 2 columns in one field and merge for e.g. category and date in order to eliminate duplicates. but it doesn't work as I expected.
Attached data file
Thanks,
Swetha J
Solved! Go to Solution.
Hi @Swethaj1994!
You should use the Cross Tab Tool in this situation. And group by Category and Date.
See attached workflow.
Cheers,