Filter Lookup Records
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?
0
Comments
Jack Hansen are you using transformation 2.0? By default it shouldn't error out. Can you screenshot your setup?
Tyler Lamparter 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

Jack Hansen 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
Please sign in to leave a comment.