how to create a field in load script?

[#1]

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?

[#2 · Accepted solution]

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");

[#3]

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");

[MayilVahanan]

HI

Try like this

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

SQL SELECT Campaign

FROM adgroup

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

[tamilarasu]

Hi Sean,

Try like.

Data:

Load *,

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

SQL SELECT *

FROM adgroup

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

[#6]

This should do;

Data:

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

SQL SELECT *

FROM adgroup

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