Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
geetha_n
Contributor III
Contributor III

get the updated data and insert to target data with other existing data

I have Source table, something like below

(has to be done in QlikView)

1.PNG

1.PNG

I have to insert a new row from Table1 to table2 as (a     zz     10     3.45     34.5)

the last 3 coloums is from table 1 for c1=a

1 Solution

Accepted Solutions
avkeep01
Partner - Specialist
Partner - Specialist

Hi Geetha N,

Im not sure if I understand you. You want the last row of table 1 added to table 2?

CONCATENATE (table2) LOAD

C1,

C2

RESIDENT table1;

but I don't know how you want 10, 3.45 and 34.5 to be linked. As far as I understand that are the values linked to table1.C1 = a.

So maybe start the script as follows:

LEFT JOIN (table1) LOAD

C1,

// C2, // Not used because zz isn't a value in table 2

C3,

C4,

C5

RESIDENT table2;

Then use the earlier posted script

CONCATENATE (table2) LOAD

C1,

C2,

C3,

C4,

C5

RESIDENT table1;

DROP FIELDS

C3,

C4,

C5

FROM TABLE table1;

View solution in original post

2 Replies
avkeep01
Partner - Specialist
Partner - Specialist

Hi Geetha N,

Im not sure if I understand you. You want the last row of table 1 added to table 2?

CONCATENATE (table2) LOAD

C1,

C2

RESIDENT table1;

but I don't know how you want 10, 3.45 and 34.5 to be linked. As far as I understand that are the values linked to table1.C1 = a.

So maybe start the script as follows:

LEFT JOIN (table1) LOAD

C1,

// C2, // Not used because zz isn't a value in table 2

C3,

C4,

C5

RESIDENT table2;

Then use the earlier posted script

CONCATENATE (table2) LOAD

C1,

C2,

C3,

C4,

C5

RESIDENT table1;

DROP FIELDS

C3,

C4,

C5

FROM TABLE table1;

geetha_n
Contributor III
Contributor III
Author

Hi