Upload -Data Shuttle

HZAR

I have follow all the step in setting up the data shuttle upload and do only for 1 mapping buts when I want to Name the workflow it give the error-One or more of your sheet columns names are using the same name. Update the sheet columns in the mapping to only use unique names.

Screenshot 2023-10-31 150112.png

Screenshot 2023-10-31 145923.png

Genevieve P.

Hi @HZAR

Can you post a screen capture of the source file's column names (but block out sensitive data)? Is is possible that some of your columns (even ones not mapped) have the same exact name?

HZAR

Agile LCP1.xlsx

Requests Tracking.xlsx

Hi Attached is the file example-just the header. Rite now I want to map 2 column from Agile.LCP1 to the Request Racking since tthe data from Agile is huge and cannot support with smartsheet sheet. Is this what ur looking for. Pls help to advise

Genevieve P.

Hi @HZAR

In the Mapping part of the workflow, is it possible that you used the +Add a new column button to create a column in the destination sheet instead of using the dropdown list to find that column?

The error message you're seeing will occur if there are two Sheet Columns with the same name:

Does that help?

HZAR

I have added as per suggested but still given me the error when want to save the workflow

Genevieve P.

Hi @HZAR

My apologies for not being clear - the suggestion is to make sure you have not added a column, but instead are using the one that already exists in the sheet.

Did you click "+add a new column" or are you using one that exists?

HZAR

I have using add a new column since my 1st trial out is using the map to existing column from source to target is not working and given me the error. Let me try again and see.

Pranav M

Hi @Genevieve P.
Even I am facing same issue as HZAR and I checked all your suggestions and I vent used add new column feature and my destination sheet does not have any duplicate columns and even mapping does not have duplicate column names from sheet. Can you please help me with this?

Genevieve P.

Hi @Pranav M

Instead of Adding a column, the workflow should already find the column name and then you select it from the dropdown. Is this what you're doing?

If you're still having trouble, you can contact Smartsheet Support with a screen recording showing the mapping and both files (source and destination). They can troubleshoot with you in a private channel. 🙂

Cheers,
Genevieve