We are currently utilizing a Google Sheets connector to a worksheet that has a series of data that contains old logic that we wish to calculate within Pigment going forward. In this particular example, the Google Sheet worksheet contains both Annual Amounts (which we want to import), as well as Monthly Amounts (which we want to ignore and recalculate within Pigment as this was using a historical spread methodology to be augmented in Pigment). We are finding during the configuration of the Import, when we elect to Ignore (delete the columns from the import definition) and kickoff the integration we get failures, stating the following:
- Is it assumed that in the below example, the desired data must come first and cannot be situated after data that is desired to be ignored?
- Is ignoring columns when utilizing a Google Sheets Connector not allowed?
Best answer by jacob.aguonView original
Hey there @ELeff_Acc!
I will be creating a ticket for you on your behalf. Please check your email in a bit and we can go over this issue together via a Support case.