3 Replies Latest reply on Dec 7, 2017 9:55 AM by Gustavo del Gerbo

    Passing Multiple Criteria - CMDBlookup step

    Mike White

      Is there a way of passing multiple criteria to the CMDBlookup step in Spoon/Kettle?

       

      Looking to replicate the following type of SQL query:

       

      SELECT Name, Company

      FROM SMIT_SID_SERVICE_OS3_Custo3871

      WHERE DatasetID ='BMC.ASSET'

      AND MarkAsDeleted is NULL

      AND propagatedAddressName in ('item1','item2','item3')

      AND CustomAttribute6 in ('selection1','selection2')