QVW load

[#1]

Good morning -

I am extremely new to QV and have what is probably a basic question.

My company's BI group creates a refreshed .qvw file everynight and posts it to a shared location.

I then open QV on my local machine and run a binary script to load that .qvw file Binary [\\path\filename.qvw];

Is there a way to modify the binary script so i can limit the fields that are loaded?  I really only need to use about half of the available records. Because i am using my local machine the reduced size would be beneficial.

Thank you.

[Anonymous]

Adam,

The exists() function looks for a field in all previously loaded data, not just the previous table.  In your case, it exists in the table DIMSTUDENT.  You can do something like this:

FCTLEADACTIVITYNEW:
NOCONCATENATE
LOAD *, %genmksystudent_id as existingstudent
RESIDENT FCTLEADACTIVITY WHERE (%gencampus_id=1 or %gencampus_id=2) and year(leaddate_timestamp)>=2014;
DROP TABLE FCTLEADACTIVITY;
 

DIMSTUDENTNEW:

NOCONCATENATE

LOAD *

RESIDENT DIMSTUDENT where exists (existingstudent, %genmksystudent_id);

DROP TABLE DIMSTUDENT;

DROP FIELD existingstudent;

[isorinrusu]

Oh, sorry for my previous answer Adam.

The problem is that you already have all the values of %genmksystudent_id loaded in your model, when loading the binary.

I can't see any workaround to it.

[#4]

Worked like a charm, Michael!  Thank you!

Great explanation as well.  Didn't dawn on me that it would be checking the entire database for the %genmksystudent_id values.