Hello RK,

Are you bringing in the device status as part of your ETL mapping? If so, then you would just need to make your CI Class mapping (Step 3) conditional where status != retired. If you're not bringing in the device status you're going to have to do a lookup in the Preview and Prepare Data (Step 2) to determine if the device is in a retired state then you can set an output variable to true/false. With that you can make the class conditional in the Class Mapping (Step 3)

Hi @Joe S1 I do have a similar issue with RK atm except that we do both insert of new record and update if record is existing. I did the same instructions above and it does work of not updating the records that does not match the values I set e.g. if u_serial_number is True and u_ci_class is Software. However by doing so it also skips creating new record. We still need to be able to create new records using the same ETL if the name is not existing (does not match) and serial number is false then it should still create new record. How do I do that?

@Rowella Montell 

Sounds like a possible problem with your conditional class, what are the conditions that you have set on the class you're mapping to in Step 3?

Hi @Joe S1,

Please see below screenshot I have for my condition in PDI.