Generic Load including IF statement / condition

[TimoHart]

Hi, 

following code work fine. However i need to FILTER all WBS which do not end with 142 from the master table. 

Master:
generic load
left("WBS Element",17),Status,"Oper./Act.", "Latest finish"

Resident StatusTable;

where and how to include a if condition to check the WBS String accordingly ? 
//if (right("WBS Element",3) = '142') then

// end if

[rwunderlich · Accepted solution]

Master:
generic load
left("WBS Element",17),Status,"Oper./Act.", "Latest finish"
Resident StatusTable
where  right("WBS Element",3) = '142'
;

-Rob