I have a load script like this:
LOAD
if(Round(date((date([Pep due date], 'DD/MM/YYYY') - date(Now(), 'DD/MM/YYYY')),'DD')) > 30, 'G',
if(Round(date((date([Pep due date], 'DD/MM/YYYY') - date(Now(), 'DD/MM/YYYY')),'DD')) <= 29 and Round(date((date([Pep due date], 'DD/MM/YYYY') - date(Now(), 'DD/MM/YYYY')),'DD')) > 0, 'A',
if(Round(date((date([Pep due date], 'DD/MM/YYYY') - date(Now(), 'DD/MM/YYYY')),'DD')) <= 0, 'R'))) AS Group;
SQL SELECT
c.duedate AS 'Pep due date'
FROM LacTest.dbo.table a
join lactest.dbo.include b on a.upn = b.upn
left join lactest.dbo.pep c on a.upn = c.upn
where b.active = 1;
The first part of the script is supposed to sort the data into one of three groups so that I can do a RAG pie chart. The second part loads data from an SQL table.
But when I run this script only the Group table is create in qv - no data from SQL at all!
Please can someone explain why?
