concatenating dynamic fields

pgandhi

I have got a set of fields whose number is dynamic i.e sometimes data might return 5 fields and sometimes 10. Now, I need to create another field which is a concatenation of these dynamic fields.
For example, if my data is returning 'Field 1', 'Field 2' and 'Field 3' then I need to create a field as 'Field 1, Field 2, Field 3', and if next time it return 'Field 4' as well then I sould be able to concatenate that as well.

Joe_Mako

One option is to use the Transpose and Summary Tools. Here is an example tool layout and sample starting data:



There here is the configuration of the Transpose tool, notice that the fields that we do not want to concatenate are selected as the Key Fields, and "Dynamic or Unknown Fields" is selected in the Data Fields, these Data Fields will be concatenated together:



Finally will can use the Summary tool to concatenate the reshaped data, Grouping by the fields selected as Key Fields, and concatenating Value from the Add button String->Concatenate, also you can set the separator:



That will produce an output of:

?