I am currently working on a script, which contains one step where two databases are joined. I was hoping that someone may have a way to validate that my 2 fields to match on, are identical and able to be matched on. I currently have parts of the script that validate 'numeric' or 'date' fields, but am unaware how to validate the match. Thanks in advance for any help!.
kkeller
Offline
Last seen: 7 years 10 hours ago
Joined: 08/09/2016 - 10:13
Hi Kyle,
What you need to do is get the field type before performing the join and then comparing the two field types to make sure they are the same. Here is some example code that does this. This uses the sample files for the example.
Hi Brian,
Perfect sample! I was able to work it in with my original script and everything is running as it should. Thanks for your help!
Glad it is working and glad to help.
Brian