I have a lookup that I need to perform only if a certain boolean is true. I used the "Filter" step with the "Database Lookup" step to perform this. The problem is that the "Database Lookup" steps adds a new field to the stream, which causes the "varying number of fields" error. Adding a constant doesn't work because the "Database Lookup" step still adds a new field, with just an "_1" appended to the end. What's the recommend way to go about this?
Thanks!
Send the stream when boolean is true to "Database Lookup" step and when boolean is false to a stap which add a constant with the same name as the Database Lookup step will add and then merge the 2 streams together