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.
Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.
I have a dataset where the values for each batch in the two columns are concatenated and separated by comma (,) and shown in a single cell.
I now want to separate each value in each cell in the acDuration and numberOfStops columns and show them one by one by each batch in each cell.
I thought to give a try using transpose tooland also I tried by using Text to columns tool by choosing Split to rows option but, no luck because, there are multiple values where in one cell there are 3 and in another cell there are 10 and in another there are 8 etc. So, this split to rows values for these two columns based on the batch number should be dynamic.
@stj1120 after splitting the field "accDuration" for the first cell (14,537,237,393,851,400,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000) returns 52 records, and the field memberOfStops returns (1,2,3,1,2,2,2,6,5,3,2,1,1,1,1,2,1,2,1,1,1,3,1,3,3) 25 records, how are you matching each accDuration with memberOfStops? It would be great if you upload the expected result for better understanding.