Concatenate two tables and just replacing a specified column

[#1]

Hello Experts,

I am starting to learn concatenate function in Qlikview and I want to replace column f2 from table 2 into table 1

so the intended result as the following table:

f1	f2	f3
a	a	c4
b	b	c5
c	b	c6
d	b	c2
e	c	c3

table2:

f1	f2	f3
a	a	c1
d	b	c2
e	c	c3

table1:

f1	f2	f3
a	b	c4
b	b	c5
c	b	c6

I used the code below and the result table turn out to be this:

f1	f2	f3
a	a	c1
a	b	c4
b	b	c5
c	b	c6
d	b	c2
e	c	c3

LOAD f1,

     f2,

     f3

FROM

C:\table1.xlsx

(ooxml, embedded labels, table is Sheet1);

Concatenate

LOAD f1,

     f2,

     f3

FROM

C:\table2.xlsx

(ooxml, embedded labels, table is Sheet1);

PLEASE HELP!!! THANKS IN ADVANCE!!

[nizamsha]

table1:

LOAD * Inline [

f1 ,f2, f3

a ,b ,c4

b ,b, c5

c ,b ,c6

]  ;

table2:

LOAD * Inline [

f1, f2, f3

a, a, c1

d ,b, c2

e ,c, c3

]where not exists(f1) ;

paste this one u will get what u want

[tresesco]

PFA

[#4]

Hello Dear,

Sorry it does not produce this table

f1	f2	f3
a	a	c4
b	b	c5
c	b	c6
d	b	c2
e	c	c3

[#5]

Hello Dear,

seems like everyone is misunderstanding what I am asking for...my bad for state it clearly in the posting..

='(

I want to get this result:

f1	f2	f3
a	a	c4
b	b	c5
c	b	c6
d	b	c2
e	c	c3

[#6]

I am sorry that I could not open this using my free personal edition..