Discussion Board for collaboration on QlikView Scripting.
I'm a beginner in QlikView and I need some help to understand concatenation...
I have a table like this :
Table_A (Rot_NB, FL_NB, Dep, Arr, Date)
I would like to concatenate :
== To have : 111, 99/99/98, AA-BB-CC-DD, Date ... Or 222, 88/88, CC-GG-CC, Date
Is it possible to do this in QlikView (in a script) ?
Thank you in advance for your help
Go to Solution.
Use Concat() function in the script, like:
Concat(FL_NB,'/') as NewFL_NB,
Concat(Dep, '-') as NewDep,
From <> Group By Rot_Nb, Date ....;
you can also concatenate using & simbol.
fl_nb & '/' & rot_nb as newfield
1)You need to use Concat(FL_NB,'/') as NewFL_NB in the script
2) You can do
You can also do the same at UI level
in a text box
Thank you !
I found a solution to my problem but I have to load all my data to a temp_table (as I select * from a table in ODBC)
then do a load resident with concatenation and group by.
But it seems that it uses a lot of memory..