topic Script help in QlikView

Script help

samvile18 — Fri, 20 Sep 2013 09:28:07 GMT

Morning all,

I have the following script which is loading two tables into one:

LOAD Age,

WRKTYPE,

SQL Select *

FROM Age.qvd

Left Join

Load WRKTYPE,

ASL,

SQL Select *

FROM ASL.qvd

Now I need to add a calculated field based on the Age-ASL...how do I do this considering the field doesn't exist within the table until I add it?

Re: Script help

sujeetsingh — Fri, 20 Sep 2013 09:37:15 GMT

Use like this :

Table1:

LOAD Age,

WRKTYPE,

SQL Select *

FROM Age.qvd;

Left Join

Load WRKTYPE,

ASL,

SQL Select *

FROM ASL.qvd;

TableCombined:

Load

Age

,WRKTYPE

,ASL

,if(Age='X' and ASL='Y',1,0) as Numerator

Resident Table1;

DROP Table Table1;

Re: Script help

Fri, 20 Sep 2013 09:44:30 GMT

Try this:

TempTable:

Load WRKTYPE,

Age-ASL AS [Your field]

Resident　<Your table name>;

LEFT JOIN <Your table name>

Load *

Resident TempTable;

Drop table TempTable;

Re: Script help

jagan — Fri, 20 Sep 2013 09:47:40 GMT

Hi,

Try this

DataTemp:

LOAD Age,

WRKTYPE;

SQL Select *

FROM Age.qvd

Left Join

Load WRKTYPE,

ASL;

SQL Select *

FROM ASL.qvd

Data:

LOAD

Age - ASL AS CalculatedValue

RESIDENT DataTemp;

DROP TABLE DataTemp;

Regards,

Jagan.

Re: Script help

er_mohit — Fri, 20 Sep 2013 10:03:10 GMT

Temp:

LOAD Age,

WRKTYPE,

SQL Select *

FROM Age.qvd

Left Join

Load WRKTYPE,

ASL,

SQL Select *

FROM ASL.qvd;

Final:

load *

Age-ASL as Calculated

resident Table;

drop table Temp;

hope it helps