how to get the unmatched data in two tables

[Anonymous]

Hi,

I have two tables from this i need to fetch the unmatched date fields a new table(Table3).

Table1:

5/15/2017

5/16/2017

5/17/2017

5/18/2017

5/19/2017

5/20/2017

Table2:

Date

5/17/2017

5/18/2017

5/19/2017

5/20/2017

5/21/2017

5/22/2017

My expected output table:

  Table 3:

5/15/2017

5/16/2017

5/21/2017

5/22/2017

thanks,

yuvaraj g

[ecolomer]

See this:

Fetch unmatched rows

[Anonymous]

Hi Colomer,

I tried this method but its giving second table unmatched date output like this,

5/21/2017

5/22/2017

But i need two tables unmatched date.

[el_aprendiz111]

Hi,

Table1:
LOAD * Inline
[
Date
5/15/2017
5/16/2017
5/17/2017
5/18/2017
5/19/2017
5/20/2017
];

NoConcatenate
Table2:
LOAD * Inline
[
Date
5/17/2017
5/18/2017
5/19/2017
5/20/2017
5/21/2017
5/22/2017
];

[dat1]: LOAD Concat(CHR(39) & Date & CHR(39),',') AS Dat1 Resident Table1;
LET Date1 = Peek('Dat1');
[dat2]: LOAD Concat(CHR(39) & Date & CHR(39),',') AS Dat2 Resident Table2;
LET Date2 = Peek('Dat2');



NoConcatenate
sumary:
LOAD *  Resident Table1 Where not wildMatch(Date, $(Date2));
LOAD *  Resident Table2 Where not wildMatch(Date, $(Date1));


DROP Table dat1,dat2,Table1,Table2;

EXIT Script;

[sibusiso90]

Can you please send a sample of what you did I am interested at the result.

[Anil_Babu_Samineni]

Just copy and paste the code in your environment and Reload. you will achieve

[Anil_Babu_Samineni]

Just to add, He may need full structure so that don't drop T1, T2

DROP Table dat1,dat2;

[Anonymous]

i tried above script its working fine on inline load but its not working on Excel source. Am getting all my Date values into one table.

[Anonymous]

Hi Fer,

Script is working fine on inline load am also get that same output but I replace the source from inline to excel data it will give all date values.

[el_aprendiz111]

Hi,