Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Great that worked
Try using the third parameter like:
Concat(Age,',', Aggr(RowNo(), Age))
Concat(ID,',', Aggr(RowNo(), ID))
Great that worked
Hi
it works for me with physical order like this :
concat(ID,',',num(FieldIndex('ID',ID)))
regards
Great! Please mark the correct reply as 'Correct'