Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

brucemazynzolt
New Contributor II

Straight Table Concatenation of two columns

Hi All,

I am trying to get the require column(Final Data) in the below table

I have two columns in my straight table called Data1 and Data2 so I need to concatenate and get the required column called Final Data and this should be done in design level only, not in script level.

 

Data1Data2Final Data
-APAP
-abcdef-
PackingAPAP / Packing

Packing

abcdef

abcedf

---

Any suggestions or help is highly appreciated.

Thanks,

Bruce

7 Replies
Chanty4u
Esteemed Contributor III

Re: Straight Table Concatenation of two columns

try

=Data1&Data2

Chanty4u
Esteemed Contributor III

Re: Straight Table Concatenation of two columns

or

Data1 &' '& Data2 as  FieldData

Digvijay_Singh
Honored Contributor III

Re: Straight Table Concatenation of two columns

Whats the logic to calculate Final Data. The output you have shown looks like not following any pattern. May be I am missing something?

isingh30
Valued Contributor

Re: Straight Table Concatenation of two columns

What's the logic behind this requirement. It's very confusing. First result is AP & second one is null why?

Why last result is data 2 not 1?

Thank you!

Highlighted
brucemazynzolt
New Contributor II

Re: Straight Table Concatenation of two columns

Here the Data2 column data 'AP' is important to display.

Yes you are right we need to write logic to display the data as shown in the table

Thanks

isingh30
Valued Contributor

Re: Straight Table Concatenation of two columns

'important to display' is not a logical thing. You have to work on you requirement part. There has to be a criteria for everything.


Thank you!

zebhashmi
Valued Contributor

Re: Straight Table Concatenation of two columns

Your Table does not have Logic.

if you just want then togaher

yes

Data1&'/'&Data2

will work otherwise you can use if on the top of it.