I'm new to QlikView and I'm asked to duplicate an Oralce SQL script into QlikView. The Oracle SQL loads a table with Insert and Select and then Updates 1 field in this table from another table if it finds a match. Using the example tables below, Table 1 is loaded; it has a Location field. Table 2 is loaded; it also has a Location field. Then the UPDATE statement is used to change the location in Table 1 if a match is found in Table 2. How can I accomplish this in QlikView beyond the simple LOAD and SQL SELECT to load the 2 tables?
Example:
| Table 1 | |
|---|
| Key | Location |
| A | 1F |
| B | 2G |
| C | 5B |
| F | 9X |
| Table 2 | |
|---|
| Key | Location |
| A | 9ABC |
| G | J4 |
The resulting Table 1 would be:
| Table 1 | |
|---|
| Key | Location |
| A | 9ABC |
| B | 2G |
| C | 5B |
| F | 9X |
Thanks for considering my question.
