Hi,
Here is the sample data have loaded:
1. out of the given records need to take only that contain India(Used where condition)
2. Out of records contain India need to exclude records that contain Maharashtra(can please let me know the condition need to include)
Pls find the attached sample app for reference
Test:
LOAD * INLINE [
Area, Amount, Unit
Global/US/USA/LA/abc, 1, USD
Global/US/USA/CA/abc, 1, USD
Global/UK/London/LA/abc, 1, GBP
Global/Asia/India/Karnataka/Bangalore, 20, INR
Global/Asia/India/Maharashtra/Mumbai, 30, INR
Global/Asia/India/Karnataka/Bangalore, 40, INR
Global/Asia/India/Maharashtra/Mumbai, 50, INR
Global/Asia/India/Karnataka/Bangalore, 60, INR
Global/Asia/India/Maharashtra/Mumbai, 70, INR
Global/Asia/India/Karnataka/Bangalore, 80, INR
Global/Asia/India/Karnataka/Bangalore, 90, INR
Global/Asia/India/Maharashtra/Mumbai, 10, INR
Global/Asia/India/Karnataka/Bangalore, 20, INR
];
Main:
Load *,
Unit as Measure
Resident Test where wildmatch(Area,'*India*');
Drop Table Test;
