Simple Comparison of two Resident Tables

[prees959]

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

[sunny_talwar]

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

[prees959]

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):

Hope this helps.

Phil

[Kushal_Chawda · Accepted solution]

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;