How to Match and Load

[soniasweety]

Hi all

Sunny T

I have data with two fields  with text  .  in file 1 :   like below 

'Party and Node    with some rows  .   and i have  new files  with same columns and   data is adding to existing  file  so

i want to match the data and  i want to   create new file with      matching data and    newly added data into   new file.

[soniasweety]

i have tried below but not working

Old:

LOAD Party,

Node,

     AutoNumberHash128(Party,Node) as Key

FROM

(ooxml, embedded labels, table is Sheet1);

Concatenate(Old)

New:

LOAD Party,

     Node

FROM

(ooxml, embedded labels, table is Sheet2)

where not Exists(Key);

[jonathandienst]

Like this:

LOAD Party,

  Node,

    AutoNumberHash128(Party,Node) as Key

FROM

(ooxml, embedded labels, table is Sheet1);

Concatenate(Old)

New:

LOAD Party,

     Node

FROM

(ooxml, embedded labels, table is Sheet2)

where Not Exists(Key, AutoNumberHash128(Party,Node));

[jonathandienst]

If you need Key in the front end, you might want to do this:

LOAD Party,

   Node,

   AutoNumberHash128(Party,Node) as Key

FROM

(ooxml, embedded labels, table is Sheet1);

Concatenate(Old)

New:

LOAD Party,

     Node,

     AutoNumberHash128(Party,Node) as Key

FROM

(ooxml, embedded labels, table is Sheet2)

where Not Exists(Key, AutoNumberHash128(Party,Node));

[qlik_jaijhn]

Use the DISTINCT Keyword and load the tables, this will remove the duplicate records and concatenate into single table with unique records. Please see the script below:-

RoughData:

LOAD DISTINCT Party,

     Node

FROM

rough.xlsx

(ooxml, embedded labels, table is Sheet1);

LOAD DISTINCT Party,

     Node

FROM

rough.xlsx

(ooxml, embedded labels, table is Sheet2);

[soniasweety]

Sorry for late replay and miscommunication

jontydkpi

qlik.jaijhn

I need a separate column for the non matching data ?

how can i achieve this?

[soniasweety]

Sorry for late replay and miscommunication

I need a separate column for the non matching data ?

how can i achieve this?

[PrashantSangle]

Hi,

What is your final expected output????

Regards,

[soniasweety]

Hi,

I need output as   Old data as one column and newdata in one column  and   one more column  as  which newly added in newdata records to be disply

[soniasweety]

for example  i have 5records in old file and  7 records in new file    i need one more column  which is not matching in both file ..... that 2records i want to extract as seperate column