Check SQL table and store qvd into different Locations

ivandrago — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the attached Document, I need help storing a value into the variable vCount by checking if a record returns by running SQL statement on SQL server. If the variable does have a value of 1 then it will store the qvd in a particular folder.

Thanks

Re: Check SQL table and store qvd into different Locations

maxgro — Sat, 28 Oct 2017 22:40:19 GMT

temp:

Select count(*) as NUMROWS From TableA Where status = '1';

let vCount = Peek('NUMROWS');

trace $(vCount);

DROP Table temp;

Fact:

LOAD * INLINE [

ID, Product

1, ABC001

2, ABC001

3, ABC002

4, ABC003

5, ABC004

6, ABC007

];

If vCount = 1 Then

Store Fact into Fact.qvd (QVD);

Else

Store Fact into Fact_OLD.qvd (QVD);

ENDIF

topic Re: Check SQL table and store qvd into different Locations in QlikView

Check SQL table and store qvd into different Locations

Re: Check SQL table and store qvd into different Locations