Want to know unmatched records in the same table between two fields

[manoranjan_d]

How to get unmatched records in the same table between two fields:

Example:

a_NOT_Matching_to_d:

LOAD 

a,

b,

c,

d,

e,

f

FROM

(qvd)

since i want to know the unmatched data between a and d field.

[MK_QSL]

you can use where exists function... Provide sample data along with the result you are looking for.

[manoranjan_d]

can u explain in the example code how to use that, bcoz its showing error

[manoranjan_d]

can any one explain how to get unmatched records between two fields in same table

[manoranjan_d]

exists function is used to get matched dat

[#6]

Hi,

Can you provide sample data for the fields mentioned, including examples for both matching and unmatching data?

[manoranjan_d]

example "a" field has 1, 2,3,4, 5, 6,7,8,9,10

d field has 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,

so the unmatched is 11-15 i need that data.

[MK_QSL]

where not exists

[maxgro]

// test data

all_data:

load rowno() as a AutoGenerate 10;

Concatenate (all_data) load round(rand()*10) as d AutoGenerate 10;

//not matching

a_NOT_Matching_to_d:

load a as dd Resident all_data

Where not exists (d, a);