Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey, I have a METHDM.qvd file.
I have 3 columns Main Item, Sub Item, AQSTYP
My condition is -
1) If I get AQSTYP = '-' then we have to keep that record
2) If I get AQSTYP = 'R' then we have to keep that record
3) If I get AQSTYP = 'M' then we have to keep that record and then we have to take that sub item and search in Main Item and then take that record also.
Load temp:
MainItem,SubItem,AQSTYP
From SomeSource;
NoConcatenate
ExistinSubItem:
Load * resident temp
Where Exists(MainItem,SubItem);
Drop table temp;
Hey,
This three-column table is a different transformed table called Temp.
I want to check Temp.Subitem with METHDM.MainItem.
can you post some sample data in excel and expected output