Dynamic ordering of Source System Data

Nosal25

We have a system that stores a CLOD-like field in 40 character blocks, with a corresponding entry number indicating the strings place in the sequence.  Is there a way to set up a workflow to dynamically reconstruct these blocks into the original input? I have a minimum entry number of 1 and a maximum of 4738.  Also, is there a way to have it stop at a max entry number and set an flag to indicate there is more data?

Thank you in advance for your assistance. 

SeanAdams

Hey @Nosal25

There is a very cute way to do this in Alteryx using the summarize tool - summarize can group by a field, and then for text fields it can concatenate.    For your second question question - yes, you can use a filter to filter out items greater than the max, and if you find anything on this output then use a formula tool to turn it into a flag.

So if you had the following data:

ClientID	Text1
1	aaa
1	bbb
2	ccc

Then you can pump it through a summarize tool, set to group by ClientID; and to concatenate Text 1, and your output will be:

ClientID	Concat_Text1
1	aaabbb
2	ccc

Happy to mock this up if you have some test data with a mocked up output that you are looking for? 

Hopefully these hits get you going in the right direction :-)

Happy Thursday

Sean