This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.