Hi Expert,
Just a quick question. how I can create this output. @atcodedog05
Hey @AS, you can do this by using the Summarize tool to group by P code and create a concatenated list of the corresponding Z codes, then re-join to the original dataset based on P code:
If you're precious about the order of records, just use a RecordID and then sort by that to finish:
Hi Thanks for the reply.
Can you tell me if Output Column is containing "A,A,B,B,B,C,C" value and we need output as "A,B,C".
Hi @AS, do you mean for when you have a bunch of the same P/Z codes like so:
And get an output like this:
If so, just place a Unique tool before the Summarize, selecting both fields:
