Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
tresesco
MVP
MVP

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

View solution in original post

4 Replies
tresesco
MVP
MVP

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

View solution in original post

amitarusi
Contributor II
Contributor II

you can also concatenate using & simbol.

for example:

load

fl_nb & '/' & rot_nb as newfield

from table.qvd;

saumyashah90
Specialist
Specialist

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
Author

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