Data Shuttle and Join Collect formulas

gwson

Hello, I have a formula JOIN/COLLECT formula that works perfectly fine when referencing a vlookup sheet with manually entered data. Once that sheet is replaced with data shuttle workflow, the JOIN/COLLECT formula no longer displays data, resulting in an empty return (no error). All vlookup references properly reference the columns after complete data replacement.

I used to have these issues when data shuttle was first released when source data column properties were overwritten as a dropdown or date values, but I can confirm that all columns are now properly setup with general/text property. ''

So is the issue with how data shuttle imports the values itself? I can double click into the cell and I do not see any extra spaces or characters. Not sure what is going on.

gwson

Resolved by deleting the sheet and starting over.

dqsoutherland

Data Shuttle and Join Collect formulas

gwson

Mar 28, 2022

Hello, I have a formula JOIN/COLLECT formula that works perfectly fine when referencing a vlookup sheet with manually entered data. Once that sheet is replaced with data shuttle workflow, the JOIN/COLLECT formula no longer displays data, resulting in an empty return (no error). All vlookup references properly reference the columns after complete data replacement.

I used to have these issues when data shuttle was first released when source data column properties were overwritten as a dropdown or date values, but I can confirm that all columns are now properly setup with general/text property. ''

So is the issue with how data shuttle imports the values itself? I can double click into the cell and I do not see any extra spaces or characters. Not sure what is going on.

---

View Post

So i have a Join Formula and Data shuttle is stipping our part of the formula in the upload workflow. It feeds dropdowns in other sheets, and now all my dropdowns are missing data. I'm hoping there is some other resolution, deleting a sheet isn't an option for me.