How to concatenate columns in Qlikview

[#1]

Hi,

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)

Row	Rot_Nb	FL_NB	Dep	Arr	Date
1	111	99	AA	BB
2	111	99	BB	CC
3	111	98	CC	DD
4	222	88	CC	GG
5	222	88	GG	CC
6	333	77	FF	DD
7	333	78	DD	FF

I would like to concatenate :

• All the FL_NB for one Rot_NB in the same line
• All the connections Dep-Arr for one Rot_NB to have only one line (order by date)

== 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

[tresesco · Accepted solution]

Use Concat() function in the script, like:

Load

          Rot_Nb,

          Concat(FL_NB,'/') as NewFL_NB,

          Concat(Dep, '-') as NewDep,

          Date

From <> Group By Rot_Nb, Date ....;

[amitarusi]

you can also concatenate using & simbol.

for example:

load

fl_nb & '/' & rot_nb as newfield

from table.qvd;

[saumyashah90]

1)You need to use Concat(FL_NB,'/') as NewFL_NB in the script

2) You can do

load FL_NB&'/'&rot_NB&'/'&etc

You can also do the same at UI level

in a text box

[#5]

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..