Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two tables.Both tables contains employee id.i want only a mis match value.how to get it
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
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.
Hi Mani,
PFA, please specify more details on what you need to achive, so that we can help.
-Sundar
You can also make this selection without hard coding stuff in the script.
Now you have selected the employee id:s that exist in table B but not in A.
HIC
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
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
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
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;
Hi Sundar,
This is helpful but i want the mis match values are load to separate column.how this possible.