Hi!
I have a table like this on BigQuery:
id | name | description | unit_price | quantity
I imported it on Zoho and created a calculated column. Now I have this:
id | name | description | unit_price | quantity | total_price
Then, I rename some fields on BigQuery:
id | name | details | unit_value | quantity
When I refresh data on Zoho, my table changed to:
id | name | description | unit_price | quantity | total_price | details | unit_value
And now unit_price and description are empty and total_price is unknown.
So, I want to know:
1) There is a way to remove automatically those columns that is no longer on data source? Or do I need to remove manually each one of them?
2) There are a location that indicates who column had been updated or not?
Thanks in advance,
Pedro