Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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");
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");
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");
HI
Try like this
Load *, SubField(Campaign,':',1) as Campaign_New;
SQL SELECT Campaign
FROM adgroup
WHERE Day > DATE_ADD(CURRENT_TIMESTAMP(),-32,"DAY");
Hi Sean,
Try like.
Data:
Load *,
SubField(Campaign,':',1) as Campaign1
SQL SELECT *
FROM adgroup
WHERE Day > DATE_ADD(CURRENT_TIMESTAMP(),-32,"DAY");
This should do;
Data:
Load *, SubField(Campaign,':',1) as Campaign;
SQL SELECT *
FROM adgroup
WHERE Day > DATE_ADD(CURRENT_TIMESTAMP(),-32,"DAY");