Hi Guys,
I have a data set which lists out issues of an entity horizontally, see my screenshot below:
I need to transfer this data so that I record all the issues in one line for that one entity and the list out the issues in separate columns, see what I need it to look like below:
I have also created a mapping of the issues to know which column to put the issue in and what type of issue to record it as, see mapping screenshot below:
How would I be able to get alteryx to read my original data set (screenshot 1) to use the mapping guidance (screenshot 3) to populate an excel to document all the issues in one row but use several columns and map the type (screenshot 2)?
Please note this is an example and not a real client, and please also note i have 8000 lines of data to transform into this new format.
Any help would be greatly appreciated.
Hi Thanks for your help - where do I find the 'Replace Underscore' function?
Normal Replace function being:
Replace() function is being used in dynamic rename tool.
Workflow:
Hope this helps : )
Thank you so much, I understand. I am still quite new to Alteryx so might have a few further questions but thank you all!