Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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