Help with datapull

[aarohipatel]

Hi,

Attached are the tables where I am trying to pull the data from

Control Table: is a table which is updated every month.

Datapull table is the table from which I am trying to pull the data from.

What I want to do is: create a variable vMONTH_KEY which pull the MONTH_KEY from the Control Table and then I want to give a where clause in the datapull that pulls data for only relevant to vMONTH_KEY.

In the attached file: MONTH_KEY in Control file is '1' which is for June and would like to pull data only for June into the qvw.

Want to do the dynamic datapull through the variable to pull only the data based on the MONTH_KEY in Control File.

Thanks

[richard_chilvers · Accepted solution]

I haven't looked in detail, but if you simply want to retrieve a value from the data already loaded in your 1st table, so you can use it when loading data into your 2nd table, you might find PEEK a useful function. The help, or this forum, might explain its use.

It might also be handy to give each of your 2 tables a name, or DROP the 1st table once you've populated your variable, vMONTH_KEY.