topic Re: Straight Table Concatenation of two columns in QlikView

Straight Table Concatenation of two columns

brucemazynzolt — Wed, 25 Nov 2020 16:16:04 GMT

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.

Data1	Data2	Final Data
-	AP	AP
-	abcdef	-
Packing	AP	AP / Packing
Packing	abcdef	abcedf
-	-	-

Any suggestions or help is highly appreciated.

Thanks,

Bruce

Re: Straight Table Concatenation of two columns

Chanty4u — Tue, 27 Feb 2018 16:33:46 GMT

try

=Data1&Data2

Re: Straight Table Concatenation of two columns

Chanty4u — Tue, 27 Feb 2018 16:34:36 GMT

Data1 &' '& Data2 as FieldData

Re: Straight Table Concatenation of two columns

Digvijay_Singh — Tue, 27 Feb 2018 16:37:42 GMT

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

Re: Straight Table Concatenation of two columns

isingh30 — Tue, 27 Feb 2018 16:41:37 GMT

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!

Re: Straight Table Concatenation of two columns

brucemazynzolt — Tue, 27 Feb 2018 16:45:42 GMT

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

Re: Straight Table Concatenation of two columns

isingh30 — Tue, 27 Feb 2018 16:49:21 GMT

'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!

Re: Straight Table Concatenation of two columns

zebhashmi — Tue, 27 Feb 2018 21:57:13 GMT

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.