I'm wanting to load data from a select statement where the emplid is not in a loaded table from a spread sheet. In other words, I load a spread sheet of EMPLID's and then I want to load the records from the HR database only for those EMPLID's that were on the spread sheet. I can't figure out if I can do a load of the select statement with a where clause and then use a sub select for where the emplid exists in the QVD file, or something like that. Any Ideas?
Solved! Go to Solution.
Maybe I got it wrong in the first place. But you could try this:
select * from <HR database>;
I never tried this, would be interesting if this works...
I found my problem. I had another select on another tab that also was using the EMPLID, pulling in all of the records. By using the
WHERE exists(EMPLID) on this load, and on the load I was working with, it resolved the problem.
Thanks for you help!
I've been using the text
Where not [Projection Period] like '0';
This has allowed me to exclude all the Projection periods which have a 0 for the value. Now I need to exclude another value from another field. I initially tried
Where not [Projection Period] OR [Scenario] like '0' OR 'X';
Where X represents the scenario I wish to exclude and while it works it also slowed the load statement to a crawl. I'm sure there is a way to split these up and I just don't know how. Could you offer any advice?