Data Shuttle Merge

kira11

Hello. I have a data shuttle set up to merge changes into a grid. I have a column that is called ID in both that is the same, but when I run it no changes are made. I have added fake changes to ensure something would happen but still nothing. My thought is maybe since the ID is a concatenation of other cells in both the source and destination, but the output is the same so I don't think that should matter.

Any thoughts?

kira11

I just figured it out! I had the SS formula set as a column formula since my sheet has so many rows. But swapping it to cell formula fixed the issue and now the Data Shuttle is running smoothly. I appreciate your help though!

acurran

Hi @kira11, this could be due to a few different things.

1. Are any of the fields you want to replace formula columns? Data Shuttle cannot override the values in a formula column.
2. Did you use a different field as the unique identifier column? If you used the ID field as the Unique Identifier then it is looking for that field to base the updates on and won't change it.
3. Are there duplicate values in the ID column? The Data Shuttle may only update the first instance of the value, which may match what you have in your sheet.

Sharing some pictures of your setup can help others identify the issue as well.

kira11

Thanks for your answer!

1. I am just replacing value columns. Essentially the sheet is tracking items as they go through the process but occasionally the item properties change and I wanted to have this data shuttle push those through so they are all just text/number.
2. The unique identifier shouldn't change ever for this. I have one ID field in the Excel source sheet and on ID column in the smartsheet grid with matching values.
3. As far as I have spot checked there are no duplicates and I tried it with the first row just in case.

What pictures would be helpful? I'm very stumped but can provide any that might help get to the bottom of this.

Paul Newcome

How exactly are you generating the unique id? Screenshots of the source, target, and data shuttle build would be helpful.

kira11

There are two columns in the source and destination: Drawing # and Joint #. I am doing a CONCAT in the source excel and just adding them in the Smartsheet to get a unique # to use as the ID.

Map columns for destination:

Map columns for source:

I am not using every column from the source sheet so those have been excluded in this mapping:

Paul Newcome

What are the formula that are generating the ID in both the excel and SS?

kira11

Excel: =IF(G2 <> "", CONCAT(G2,"/",J2), "")

SS: =Drawing@row + "/" + Joint@row

Paul Newcome

This shouldn't make a difference, but I have seen some strange things work before… What if you use something similar in Excel?

=G2&"/"&J2

kira11

Still not making the updates.

Paul Newcome

Hmm. Ok. Can you show a screenshot of a row in excel and the same row in SS? The ID, Drawing, and Joint columns.

How is the ID getting from Excel to SS?

kira11

I just figured it out! I had the SS formula set as a column formula since my sheet has so many rows. But swapping it to cell formula fixed the issue and now the Data Shuttle is running smoothly. I appreciate your help though!

Paul Newcome

That's odd the column formula would affect that. Glad you got it working though.