Skip to main content

EMEA Admin Office Hours - 27/02/20

  • February 24, 2020
  • 3 replies
  • 112 views

baji_bathula
Forum|alt.badge.img+4

This thread is for the Admin Office Hours session for Thursday Feb 27th,2020. Submit your questions to this thread and we'll address them during our session at 1p-3p GMT

There is no need to register for the sessions anymore. If you have a question, please post below or join the meeting. I will go in order of posts below or joining the session.

Thanks!!

GoToMeeting:

https://global.gotomeeting.com/join/860695853

You can also dial in using your phone.

United States: +1 (571) 317-3117

Access Code: 860-695-853

More phone numbers

United Kingdom: +44 330 221 0097

3 replies

  • Contributor ⭐️
  • February 26, 2020

Hello, 

 

I import my data through an S3 bucket. Recently, I have changed the header in the csv file that I have been updating. The data is the same, only the header has changed. How do I change the header for the past imports and use the same rule to import the new data going forward? 

 

Second, for another S3 import I have a duplicate column name. How do I deal with this? 

 

Thank you, 

Christina 


baji_bathula
Forum|alt.badge.img+4
  • Author
  • Gainsight Employee ⭐️
  • February 27, 2020

This session starts at 1:30 pm today


baji_bathula
Forum|alt.badge.img+4
  • Author
  • Gainsight Employee ⭐️
  • February 27, 2020

@christinav For the first question, we have to click Load Columns in the S3 dataset. Then all the new columns(header) will be reflected.

 

For the second question, If we have duplicate columns in the CSV file, Rule or S3 job will fail. We need to rename the duplicate column in CSV file.