topic Re: Load scripting from SQL in QlikView

Load scripting from SQL

irmantas — Sat, 16 Nov 2024 01:28:15 GMT

Hello,

Is it possible, in loading data from SQL, add new field using IF condition.

Ex: IF(DataTo<Today(),'True','False') as NewField

martinpohl — Mon, 20 Jan 2020 14:50:08 GMT

how should this work?

You are loading a number of lines.

In one Date<today(), in the next line maybe not.

You can't delete a field in a table for a single line (or a number of lines).

You can load all datas < today and next = today() in two diffenrent tables

irmantas — Mon, 20 Jan 2020 14:59:54 GMT

I want to load all data from table. I just want add new field in line, with some information about one of fields from this line.

If ToDate<Today(), True,False

For ex (Today 01/20/2020):

Id FromDate ToDate NewField

1 01/01/2020 01/19/2020 'True'

2 01/01/2020 01/25/2020 'False'

Kushal_Chawda — Mon, 20 Jan 2020 15:08:07 GMT

Yes. using preceding load you can do that

LOAD *,

if(ToDate <today(),'True','False') as Flag;

SQL Select ID,FromDate,ToDate

FROM db.tablename;

martinpohl — Mon, 20 Jan 2020 15:13:28 GMT

so you give the code by yourself in the first post....

irmantas — Tue, 21 Jan 2020 07:37:15 GMT

Thank you. Its works.