Data Shuttle adding blank rows
Best Answer
-
Hi Steve,
Thanks for elaborating! Yes, it sounds like the attachment is exactly what's causing the blank row. That row is then "used" so even though the cells are blank, then new data coming in will want to populate a fresh, un-used row (unless you're merging data).
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @millers150
I would suggest adding in a filter to your Data Shuttle configuration that ensures it's only pulling in rows that aren't blank.
Is it also possible you have a header row in the Excel file? If so, you can set your Data Shuttle workflow to start at row 2.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Hi Genevieve, thank you for the response!
I believe I figured out what was happening. I wanted to be able to load an excel scorecard into the Smartsheet, have data shuttle pull the information and then have that excel file be attached to each row.
I think what happened was the Data Shuttle would see the file attached and count this as a "full row". It would then move on to the next row to populate the data. It looked like a blank row but had the attachment in it.
Row 1: Attachment 1
Row 2: Attachment 1 Information
Row 3: Attachment 2
Row 4: Attachment 2 Information
I'm not sure if there is a work around, but I have the teams just dragging the excel file to the first row for now to avoid getting the blank row.
Thanks
Steve
-
Hi Steve,
Thanks for elaborating! Yes, it sounds like the attachment is exactly what's causing the blank row. That row is then "used" so even though the cells are blank, then new data coming in will want to populate a fresh, un-used row (unless you're merging data).
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives