Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there. Hopefully an easy one.
I've recently been given access to a datafeed from googlecloud to replace updates provided on spreadsheet.
However i'm unsure how to edit the field names, and add calculated columns etc like when I was loading the spreadsheet data. In my load script there is a LOAD script which lists all the columns, and then below it there is a table name with a SELECT script which lists the columns again.
So my question is, If I want to:
* rename the columns,
* add calculated columns etc etc.
Do I add these in in the load statement, or the select statement? What is the difference?
I've tried adding amending both the LOAD script and the SELECT script separately but get an error each time, saying it can't find the first field.
So first of all. If I need to amend a script from a feed. Do I amend the LOAD statement or the SELECT statement?
Is there anything else I need to do in order to use this data and add additional feeds?
I've managed to sort this. All data manipulations were done in the LOAD script rather than the select script.
The error is saying invalid expression but it doesn't give me any detail on what the issue is.
From the below, my select statement is incorrect, but I'm not sure why. Could be something really basic, can anyone help?
I've managed to sort this. All data manipulations were done in the LOAD script rather than the select script.