Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to concatenate columns in Qlikview

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)

RowRot_NbFL_NBDepArrDate
111199AABB
211199BBCC
311198CCDD
422288CCGG
522288GGCC
633377FFDD
733378DDFF

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

1 Solution

Accepted Solutions
MVP
MVP

Re: How to concatenate columns in Qlikview

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

4 Replies
MVP
MVP

Re: How to concatenate columns in Qlikview

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
New Contributor II

Re: How to concatenate columns in Qlikview

you can also concatenate using & simbol.

for example:

load

fl_nb & '/' & rot_nb as newfield

from table.qvd;

saumyashah90
Valued Contributor

Re: How to concatenate columns in Qlikview

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

Not applicable

Re: How to concatenate columns in Qlikview

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

Community Browser