Is there a way to filter records within a lookup step before they get to the transformation of the step? I have a lookup that grabs multiple records based off an id and if one of the records doesn't have the information the transformation is looking for the step fails for the whole record, is there a way to prevent these records from hitting the transformation step/not show in the results?
@jackhansen are you using transformation 2.0? By default it shouldn't error out. Can you screenshot your setup?
@tylerlamparter I had not been using 2.0. I believe I have just converted it over now, I will attach screenshots of the 1.0 and 2.0
@jackhansen yeah transformation 2.0 should work for you here. You can add a filter after it since it won't fail if it doesn't find something. Here is a good article and video on how to use transformation 2.0 and why it's better than 1.0. https://docs.celigo.com/hc/en-us/articles/12581205330587-Transformation-2-0