Here is the example for your question:
Let us assume the below data:
Temp:
LOAD * INLINE [
Name
A
];
Data:
LOAD * INLINE [
Product, Name, Sales
Product1 , A, 673
Product2, B, 676
Product3, C, 679
Product4, A, 682
Product5, B, 685
Product6, C, 688
Product7, A, 691
Product8, B, 694
] Where Exists (Name);
I have data table, in that i want to load only some specific value from that , in that case i will create one more table with name field wthich i want ion main table and then i ll use where exists function.
I hope you understood.
-Nagarjun
