topic Re: Load data into QVD only if data present in SQL tables in Connectivity & Data Prep

Load data into QVD only if data present in SQL tables

jobsonkjoseph — Wed, 10 Apr 2019 09:45:21 GMT

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.

Re: Load data into QVD only if data present in SQL tables

fosuzuki — Thu, 11 Apr 2019 00:05:04 GMT

Try something like this:

Data:
SQL SELECT * FROM TABLE;

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

Re: Load data into QVD only if data present in SQL tables

jobsonkjoseph — Fri, 12 Apr 2019 06:34:45 GMT

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