Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

pavanthota
New Contributor III

Concatenation of two fileds

Hi

I have two tables below like this

Table1:

Load

a,

b,

c,

d

From   ;

Table2:

Load

a,

e,

f,

g

From ;

I need to satisfy the below condition and get the final table like this

Finaltable:

Load

a,

b,

e&c as c,

d

From

where a=a;

Can any one please help me

1 Solution

Accepted Solutions
Employee
Employee

Concatenation of two fileds

Table1:

Load a, b, c, d From ...  ;

Join

Load a, e, f, g From ...  ;

Finaltable:

Load a, b, e&c as c, d

From ... where a= ...;

Drop Table Table1 ;

1 Reply
Employee
Employee

Concatenation of two fileds

Table1:

Load a, b, c, d From ...  ;

Join

Load a, e, f, g From ...  ;

Finaltable:

Load a, b, e&c as c, d

From ... where a= ...;

Drop Table Table1 ;

Community Browser