how do I merge to tables together based on variables I created, NOT the attributes.
I want to merge GW_Inbound with Isoft based on inputfilename of GW_inbound and storedfile of isoft.
inputfilename='aaaa/bbbb/sample.txt'
storedfile='aaaaaaaaaaaaaaaaa/bb/sample.txt'
inputfilename and storedfile both have same value of 'sample.txt' but thepathname is different. So i created variable inpurfilenamevar and storedfilevar which both have value 'sample.txt'. So how do i merge the two tables together using inputfilenamevar and storedfilevar instead of inputfilename and storedfilename.
Thanks