Solved

Google Sheet Connector Error when ignoring columns

  • 2 May 2023
  • 1 reply
  • 56 views

Badge +2

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:

 

Two questions:

 

  1. 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?
  2. Is ignoring columns when utilizing a Google Sheets Connector not allowed?

 

 

icon

Best answer by Anonymous 4 May 2023, 20:43

View original

1 reply

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.

 

Thank you!

Reply