please help to implement logic

[vipin_mishra479]

i have a 10 record and there have a different data

eg.

1 - doc

1 - koc

1 - noc

same as 2, 3 ,4 ,5 ,6, 7 ,8,9, 10

if i want to data 1 to 9 all data doc , koc and noc  but in 10 i want to only koc data then how can i implement the logic

[#2]

Hi,

You can do it in the following way:

Test:
LOAD * INLINE [
F1, F2
1, doc
1, koc
1, noc
2, doc
2, koc
2, noc
3, doc
3, koc
3, noc
4, doc
4, koc
4, noc
];


Test1:
LOAD
F1 AS record,
F2 AS data
RESIDENT Test
WHERE F1 <> 4;
JOIN
LOAD
F1 AS record,
F2 AS data
RESIDENT Test
WHERE F1 = 4
AND F2 = 'doc';

Regards vicky