topic Re: How to get mismatch values in QlikView

How to get mismatch values

Sat, 15 Feb 2014 06:29:33 GMT

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,

Re: How to get mismatch values

Sat, 15 Feb 2014 07:05:36 GMT

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

Re: How to get mismatch values

Sat, 15 Feb 2014 07:19:40 GMT

Hi bifal,

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

Re: How to get mismatch values

aveeeeeee7en — Sat, 15 Feb 2014 07:29:05 GMT

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

Re: How to get mismatch values

Sat, 15 Feb 2014 07:31:28 GMT

Hi Nag,

Please give query.Your QVW should not be loaded.

Re: How to get mismatch values

aveeeeeee7en — Sat, 15 Feb 2014 07:34:22 GMT

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

Re: How to get mismatch values

Sat, 15 Feb 2014 07:40:48 GMT

Hi Nag,

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

Re: How to get mismatch values

aveeeeeee7en — Sat, 15 Feb 2014 07:45:48 GMT

Go to Edit Script :

Remove * After Load

Re: How to get mismatch values

aveeeeeee7en — Sat, 15 Feb 2014 07:47:02 GMT

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

Re: How to get mismatch values

Sat, 15 Feb 2014 08:15:14 GMT

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;