Discussion Board for collaboration on QlikView Scripting.
I have a table with sample data as follows:
during the load I need the VLC_VALUE field to concatenate based on each unique OPT_VGUID, so the result is:
is this possible?
RowNo() as Sort
Concat(VLC_VALUE, ' - ', Sort) as VLC_VALUE
Group By OPT_VGUID;
DROP Table Table;
I found this wasn't working with the 'Sort' concatenation as you have provided.
so I amended as follows - TABLE_1:LOAD OPT_VGUID,
CHARC, VLC_VALUE, RowNo() as OPT_SortFROM SOURCE;NEW_TABLE:LOAD OPT_VGUID, Concat(VLC_VALUE, ' - ') as NEW_VLC_VALUEResident TABLEgroup by VGUID;
DROP table TABLE_1;
This gave the required results and works perfectly!
thanks for your help!
Try like this
Concat(VLC_VALUE, ' - ') AS VLC_VALUE
Hope this helps you.