We try to be flexible with our loads by allowing manual date range updates and changed records updates. I've created a variable to handle manual vs changed records and am looking for a way to have a conditional evaluation of this variable in a mapping. When the flag is set to manual, I filter the records based on the date range specified in a workflow table. When the flag is not set, I join to a table that contains keys of all of the changed records.
Example (I apologize for my primitive use of MS Paint):
The way I've handled this is by creating two separate mappings for each respective conditional result and assembled a package to evaluate the variable:
I'd like to not have two mappings to handle this evaluation...is there any way to route the flow inside an actual mapping with a variable evaluation or is this only possible in a package?