Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QV developers,
I have column of text like this:
Col1 |
Text10 |
Text17 |
Text3 |
Text4 |
Text5 |
Text6 |
Text7 |
Text8 |
Text1 |
Text2 |
Text11 |
Text12 |
Text13 |
Text14 |
Text15 |
Text16 |
Text45 |
Text24 |
Text21 |
Text76 |
Text18 |
I am trying to use CONCAT function in the script like this so that I can get all text values in one cell.
LOAD
CONCAT(Col1, ';') As ConcatCol
RESIDENT
Test1
The result looks like this:
|
This is not what I desire. The Text gets already sorted before the concatenation. I want the result in the same order as the rows appear in the first table like
This is what I desire
Text10;Text17;Text3;Text4 ...
How can I achieve this? Thanks for your help.
Problem Solved. I just realized we can have sort option as the third parameter inside the CONCAT function. So I am able to use the row number as the sort order. This works now. Thanks.
Problem Solved. I just realized we can have sort option as the third parameter inside the CONCAT function. So I am able to use the row number as the sort order. This works now. Thanks.