CODEWITHSUNDEEP
sqlexceldatabasestring-comparisonmap-force
DarkBlade
DarkBlade

Reputation: 57

How to check against a DB Table in Mapforce?

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?

Upvotes: 0

Views: 83

Answers (2)

Phierru
Phierru

Reputation: 399

Use the new Join Component. If you click out the [SQL] button on the top right of the component then you can join non-SQL sources.

Upvotes: 0

DarkBlade
DarkBlade

Reputation: 57

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.

SQL filter

Upvotes: 0

Related Questions