Loop

[risabhroy_03]

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.

[vinieme12]

Load temp:
MainItem,SubItem,AQSTYP
From SomeSource;

NoConcatenate
ExistinSubItem:
Load * resident temp
Where Exists(MainItem,SubItem);
Drop table temp;

[risabhroy_03]

Hey,

This three-column table is a different transformed table called Temp.

I want to check Temp.Subitem with METHDM.MainItem.

[vinieme12]

can you post some sample data in excel and expected output