Load data into QVD only if data present in SQL tables

[jobsonkjoseph]

Hi,

Can we have a solution at script level for "loading data into QVDs only if there is data in SQL tables".

SO, when a run happens and unfortunately the data in SQL table for some reason has no values, then the QVDs should remain unchanged with old records.

[fosuzuki]

Try something like this:

Data:
SQL SELECT * FROM TABLE;

If NoOfRows('Data') > 0 Then
  Store Data into Data.Qvd;
End If
Drop table Data;

[jobsonkjoseph · Accepted solution]

Hi Fosuzuki,

I've made some changes and used the following;

<table_name>:
LOAD *
SELECT * from <table>;
LET v<tablename>rows=NoOfRows('<table_name'>);
if $(v<tablename>rows)>0 then
STORE <table_name> into [lib://.../<table_name>.qvd](qvd);
ENDIF