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: 
prees959
Creator II
Creator II

Simple Comparison of two Resident Tables

Hi I have two resident tables:

CurrentLogs:

Date,

DESC

 

NewLogs:

NewDate,

NewDESC

 

Both tables are identical with one extra row in NewLogs based (if I compare DESC and NewDESC).

What I would like is to create a temp table containing this new extra row?

Many thanks,

Phil

 

 

1 Solution

Accepted Solutions
Kushal_Chawda

may be you can try below

Data:
load Date,
DESC
FROM currentTable

left join(Data)
load NewDate as Date,
NewDESC
FROM Newtable;

Final:
load Date,
alt(NewDESC,DESC) as DESC
resident Data;

drop table Date;

View solution in original post

3 Replies
sunny_talwar

Not sure I understand. Would you be able to share some sample data to show the issue?

prees959
Creator II
Creator II
Author

HI,

so, the first table is the original.  Im loading the new file in and in this example I want the new record of 'Something White' placed in a new table on its own (in a working example there could be many new records):

Screenshot 2020-07-17 at 16.04.48.png

Hope this helps.

 

Phil

Kushal_Chawda

may be you can try below

Data:
load Date,
DESC
FROM currentTable

left join(Data)
load NewDate as Date,
NewDESC
FROM Newtable;

Final:
load Date,
alt(NewDESC,DESC) as DESC
resident Data;

drop table Date;