Another Concat Order Issue

[spikenaylor1]

Batch	ID	Age
AB1234	Z46	45
AB1234	Q76	32
AB1234	B98	61
BB5678	Q34	57
BB5678	G11	34
BB5678	A34	58

I am using the concat in an expression in a straight table along with other expressions to give me my table view of all required data.

Concat(ID,',')

Concat(Age,',')

it concats as this

For Batch AB1234

ID

B98,Q76,Z46

Age

32,45,61

I need it to concat as this

ID

Z46,Q76,B98

Age

45,32,61

I need them to not sort at all, just concat in the original order

any help please

[tresesco]

Try using the third parameter like:

Concat(Age,',', Aggr(RowNo(), Age))

Concat(ID,',', Aggr(RowNo(), ID))

[spikenaylor1 · Accepted solution]

Great that worked

[ogautier62]

Hi

it works for me with physical order like this :

concat(ID,',',num(FieldIndex('ID',ID)))

regards

[tresesco]

Great!  Please mark the correct reply as 'Correct'