Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pavanthota
Creator
Creator

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
hic
Former Employee
Former Employee

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 ;

View solution in original post

1 Reply
hic
Former Employee
Former Employee

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 ;