Hi,
Can some one help me to get the multiple output with comma seperated.
I have 100o's of GPN Concat where i have multiple matches with in same cell. I need to get the multiple results as bellow(Expected result).
Not sure is there way i can get it. Kindly let me know if there is any solution.
Solved! Go to Solution.
Hi @Ranjan88,
I'd tackle this as follows:
Result:
What happens:
- First we add a RecordID to make sure we get the data back together later on
- We than split the GPN Concat with the | delimiter into ROWS
- I prefer to use a Switch-Case or a Contains for your operation. We can setup Null() as our backup
- We than summarize all rows based grouped by the RecordID. The key here is to use the concatenate function in the Summarize tool.
Settings:
Text-To-Column:
Formula:
Summarize:
I'll also attach the workflow for reference. Let me know if this was helpful and solved your problem.
Best
Alex