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.