Insert/Update using Join Snap
Hi,
I am using Join Snap, to implement the logic of Insert new record and update existing one by doing join on target table. i defined left outer join to read all input records and in router i used...
Forum Discussion
Hi,
Thanks. My requirement is to work on single Key column. here in my case i am using WRxx as key column. so i thought of using Join snap with left outer join. I got your info on this join type, that is the my idea too. when i use left outer join, i will get all records from Input0 and matched records from Input1 and for unmatched records it should retrun null as out put and i thought of using Null records as New records and matched records as update records. so, if u have any job on join snap, please advice.
Thanks in advance.
hi Pranil,
you can definitely use the join snap for this, route the nulls to one flow(insertions) and matched output(update) to other route. You can also use inner join and use option in join snap ‘unmatched data to error view’, that way the error view records would be considered for insert and the output view of join can be used for updated records.Regards
AnubhavHi Anubhav,
Thaks for the reply. As said by you, i tried to implement the same, but by using left outer join, i am not able to capture null values, this is the first thing i asked, you can see my first screen shot. if it is new value i am not getting any value for Input1 and the job is throwing error.
routing error records using inner join, i did this one using join snap and lookup snap too (using lookup also we can route the error records as new ones and can use them for insert).
so just for information, is it possible to capture null recors using left outer join in Join Snap?
hi, I am able to get nulls for unmatched data, please refer to screenshot below
Input1:Input 2:
Join result:
