Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Guys,
I have a sql
"
SELECT TxnLineID, LIST(SerialNumberName) FROM "QBAdvancedReportGroup"."v_InvoiceLineSerial"
GROUP BY TxnLineID
"
It gives me comma separated list of SerialNumberName.
I want to do the same operation on QVD files without writing a for loop.
Is there any function that QV provides to do that?
REgards,
Saurabh
Hi
Try like this
Load TxnLineID, Concat(Distinct SerialNumberName, ',') AS SerialNumberName From Tablename
Group by TxnLineID;
concat(SerialNumberName)
and if you only want distinct values
concat(distinct SerialNumberName)
Hi
Try like this
Load TxnLineID, Concat(Distinct SerialNumberName, ',') AS SerialNumberName From Tablename
Group by TxnLineID;