Dynamically Concat the fields alphabetically

[Anonymous]

Hi,

I need to concatenate different fields in my load script alphabetically leaving other fields unchanged.

Field A	Field B	Field C	Field D	Concat	Measure
alpha	Gamma	Beta	Xeta	alphaBetaGammaXeta	1000
D	A	B	C	ABCD	3000
Tom Sayer	Darren Roach	Jay Kempner	Don Burton	Don BurtonDarren RoachJay KempnerTom Sayer	4000

The desired output will be Concat field in the above example. It is basically shifting the fields left to right or vice versa alphabetically without effecting other fields.

[Anonymous]

This is a good question, but I think I will not have a situation wherein every field will start with same alphabet. Be it first name middle name or last name.

[sunny_talwar]

Will not happen, but I am just trying to understand the logic for sorting if something like this happens

[Anonymous]

I don't know about that situation. May be sorting on the first alphabets is all what is needed