How to get not equal value

[#1]

Hi,

   I have two tables.Both tables contains employee id.i want only a mis match value.how to get it

[vikasmahajan]

You can take both data in one excel sheet and cross check using Vlookup function excel

Systax   =Vlookup( Search Range,columnno, flag)

This way you can find missing records from table A -> B  and vs B-> A also.

Vikas

[jagan]

HI,

Data1:

LOAD

Emp_id,

'

'

FROM Data1:

Data2:

LOAD

*

FROM Data2

WHERE Not Exists(Emp_id);

Now Data2 table has records which are not in Data1 table.

If you are not expecting can you come up with an example and expected output.

Regards,

Jagan.

[sundarakumar]

Hi Mani,

PFA, please specify more details on what you need to achive, so that we can help.

-Sundar

[hic]

You can also make this selection without hard coding stuff in the script.

1. Right-click on a field from table A, and Select All
2. Right-click on "employee id", and Select Excluded

Now you have selected the employee id:s that exist in table B but not in A.

HIC

[#6]

In a set Analysys (I think you will get the right answer with all the answers already made):

If you have 2 dimensions not related (data island for ex). Your user has selected Dimension B, but your data is dimensionned by DimensionA:

Sum ({< DimensionA = e(DimensionB) >} DataDimensionnedByA)

If you want to link them (get the same values), use the p() function instead.

Fabrice

[#7]

hi Sundarakumar,

                         i can't able to load your unmatch.qvw document.Please send your query.I think your source file is correct as my scenario.I want only 10 and 11 values,how to get it

[sundarakumar]

Hi,

PFB

two:

LOAD id
FROM
C:\Users\379790\Desktop\unmatch\src2.xlsx
(ooxml, embedded labels, table is Sheet1);

NoConcatenate
//drop table one;
three:
LOAD id as ida,id
FROM
C:\Users\379790\Desktop\unmatch\src1.xlsx
(ooxml, embedded labels, table is Sheet1);

inner join
four:
LOAD id as id
FROM
C:\Users\379790\Desktop\unmatch\src2.xlsx
(ooxml, embedded labels, table is Sheet1);

-Sundar

[er_mohit]

try this script

TT1:

LOAD * INLINE [

    PId1

    1

    2

    3

    4

    5

    6

];

NoConcatenate

TT2:

LOAD PId1 as mismatch, * INLINE [

    PId1

    4

    5

    6

    7

    8

    9

]Where not Exists (PId1);

DROP Table TT1;

TT3:

LOAD

  * INLINE [

    PId1

    4

    5

    6

    7

    8

    9

];

NoConcatenate

TT4:

LOAD PId1 as mismatch, * INLINE [

    PId1

    1

    2

    3

    4

    5

    6

]Where not Exists(PId1);

DROP Field PId1;

[#10]

Hi Sundar,

               This is helpful but i want the mis match values are load to separate column.how this possible.