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


      WHERE DatasetID ='BMC.ASSET'

      AND MarkAsDeleted is NULL

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

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