EMEA Admin Office Hours - 27/02/20

  • 24 February 2020
  • 3 replies
  • 110 views

Badge +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

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 

Badge +4

This session starts at 1:30 pm today

Badge +4

@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.

 

Reply