The question is about mapping in Mapforce.
I have an Excel input file. I also have a table from Oracle DB.
What I want to do is the following: Take tournr from Excel and compare it to tournr in Table from DB. When there is a match, take NR column from DB table.
How can I do that?
Advertisement
Answer
I found the answer on my own. Need to use ‘INSERT SQL WHERE/ORDER’ from the menu where constant, DB’s are etc. And you can do JOINs with a couple of SQL filters like this one if connected properly.
