How to get mismatch values

[#1]

Hi,

   My scenario: I have two table AW_Table1,TD_Table2  like,

i able to load match values to separate field.But i can't able to Mismatch value load to separate field,Please give query,

my script is,

[#2]

hello... chk dis..... QVW file...  derz a simpl sollution in dis QVW...!!!!

[#3]

Hi bifal,

  I can't able to load your missmatch.qvw document,so please give query.

[aveeeeeee7en]

Hi Mani

Use Apply Map instead of Join.

Please see the Attached Qvw.

I have used inline table. You can insert your tables.

Table1:

Mapping

Load @1 AS Key,

    @5 AS AW_Table1

FROM

D:\QlikView\source\AW_Test.txt

(txt, codepage is 1252, no labels, delimiter is spaces, msq, header is 1 lines);

Table2:

Load  @1 AS Key,

      @2 AS TD_Table2,

ApplyMap('Table1',@1,'NOT Matching') as Applymapfield

FROM

D:\QlikView\source\TD_Test.txt

(txt, codepage is 1252, no labels, delimiter is spaces, msq, header is 1 lines);

Hope it works for you.

Regards

Aviral

[#5]

Hi Nag,

          Please give query.Your QVW should not be loaded.

[aveeeeeee7en]

Use this:

Table1:

Mapping

Load @1 AS Key,

    @5 AS AW_Table1

FROM

D:\QlikView\source\AW_Test.txt

(txt, codepage is 1252, no labels, delimiter is spaces, msq, header is 1 lines);

Table2:

Load  @1 AS Key,

      @2 AS TD_Table2,

ApplyMap('Table1',@1,'NOT Matching') as Applymapfield

FROM

D:\QlikView\source\TD_Test.txt

(txt, codepage is 1252, no labels, delimiter is spaces, msq, header is 1 lines);

[#7]

Hi Nag,

           when i run this script,i had received one error like,

[aveeeeeee7en]

Go to Edit Script :

Remove *   After Load

[aveeeeeee7en]

Please use this code and refer attached excel.

Table1:

Mapping

Load @1 AS Key,

    @5 AS AW_Table1

FROM

D:\QlikView\source\AW_Test.txt

(txt, codepage is 1252, no labels, delimiter is spaces, msq, header is 1 lines);

Table2:

Load  @1 AS Key,

      @2 AS TD_Table2,

ApplyMap('Table1',@1,'NOT Matching') as Applymapfield

FROM

D:\QlikView\source\TD_Test.txt

(txt, codepage is 1252, no labels, delimiter is spaces, msq, header is 1 lines);

[#10]

tabl1:

LOAD key,

     tabl1

FROM

D:\missmatch\Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

join

tabl2:

LOAD key,

     tabl2

FROM

D:\missmatch\Book2.xlsx

(ooxml, embedded labels, table is Sheet1);

output:

load tabl1,

  tabl2 as missmatch

  resident tabl1

  where tabl1 <> tabl2;