I want to get field value based on filter criteria.
ex: field1value='A',get me field2
Earlier i used set analysis to get count
Now i want just value of other field.if its of type duplication
Load * Inline
Load Type, COUNT(Number) as Flag Resident Temp Group By Type;
Load * Resident Temp where Flag >1;
Drop Table Temp;