topic how to create a field in load script? in QlikView

how to create a field in load script?

Fri, 13 Nov 2015 07:05:14 GMT

My current script is something like this:

SQL SELECT *

FROM adgroup

WHERE Day > DATE_ADD(CURRENT_TIMESTAMP(),-32,"DAY");

How do I save the expression

=SubField(Campaign,':',1)

as a field so it can be re-used easily across the sheet's charts?

Re: how to create a field in load script?

Fri, 13 Nov 2015 07:49:31 GMT

Not sure, but do you need something like this.

Campaign:

Load SubField(Campaign,':',1) as Campaign ;

SQL SELECT Campaign

FROM adgroup

WHERE Day > DATE_ADD(CURRENT_TIMESTAMP(),-32,"DAY");

Re: how to create a field in load script?

Fri, 13 Nov 2015 08:29:29 GMT

It works, thanks! You just need to add the *

I had an error earlier because of multiple load statements, which should be combined.

Here is the working script:

Load

SubField([Campaign],':',1) as Feeder,

SubField([Campaign],':',2) as Language,

SubField([Campaign],':',3) as Destination;

SQL SELECT *

FROM adgroup

WHERE Day > DATE_ADD(CURRENT_TIMESTAMP(),-32,"DAY");

Re: how to create a field in load script?

MayilVahanan — Fri, 13 Nov 2015 08:46:44 GMT

Try like this

Load *, SubField(Campaign,':',1) as Campaign_New;

SQL SELECT Campaign

FROM adgroup

WHERE Day > DATE_ADD(CURRENT_TIMESTAMP(),-32,"DAY");

Re: how to create a field in load script?

tamilarasu — Fri, 13 Nov 2015 08:47:14 GMT

Hi Sean,

Try like.

Data:

Load *,

SubField(Campaign,':',1) as Campaign1

SQL SELECT *

FROM adgroup

WHERE Day > DATE_ADD(CURRENT_TIMESTAMP(),-32,"DAY");

Re: how to create a field in load script?

Fri, 13 Nov 2015 09:28:20 GMT

This should do;

Data:

Load *, SubField(Campaign,':',1) as Campaign;

SQL SELECT *

FROM adgroup

WHERE Day > DATE_ADD(CURRENT_TIMESTAMP(),-32,"DAY");