Hey guys, I want to change a field (key) on load to another value (key), based off of the table that key is referencing.
I have made a simplified example below;
So in this case if the Group is "A" and Name is "First" the Akey should be the same as the Akey of when the Group is "B" and Akey is "Third"
The keys seem to be changing somewhere along the line, which is why I can't just hard swap them on the load.
I have added stub of my example below;
I wanted to do a load within a load, but that doesn't seem to work in qlik like it does in SQL, The data is about 4GB over a 20Meg link for the whole office, with about 40 Million lines, so I don't really want to do a select within select in sql, would be wasteful.
Any help is appreciated, thanks.