DataMesh Question

swaldon2

I have a DataMesh pulling from over 300 sheets and updating the rows every hour. I want to add a column on the DataMesh, not on the individual sheets, to track the status of each row. If I add a new column on the DataMesh will this break it?

Georgie

Hi @swaldon2 ,

It sounds like you may be using a report that has over 300 source sheets as the source for your DataMesh config, and you’re wanting to add a new column in the target sheet. Is that correct? If so, I can’t see why this would cause sheets or the config to break.

However, if you want to confirm that it works as expected, you could create a copy of the target sheet, then create a new DataMesh config with the same setup as the existing one except that the target sheet would be the copied target sheet rather than the original one. You can then try adding the column on the copied target sheet and check that all runs as desired.

You can find FAQs for DataMesh here: DataMesh FAQs - DataMesh supports up to 20,000 rows and 400 columns and can support up to 190 mapped columns. 

 Hope that helps!

Georgie 

Georgie

Hi @swaldon2 ,

It sounds like you may be using a report that has over 300 source sheets as the source for your DataMesh config, and you’re wanting to add a new column in the target sheet. Is that correct? If so, I can’t see why this would cause sheets or the config to break.

However, if you want to confirm that it works as expected, you could create a copy of the target sheet, then create a new DataMesh config with the same setup as the existing one except that the target sheet would be the copied target sheet rather than the original one. You can then try adding the column on the copied target sheet and check that all runs as desired.

You can find FAQs for DataMesh here: DataMesh FAQs - DataMesh supports up to 20,000 rows and 400 columns and can support up to 190 mapped columns. 

 Hope that helps!

Georgie 

tcleaning

Great answer!

https://community.smartsheet.com/discussion/comment/488956#Comment_488956

Should be totally fine- the test sheet is a great idea before it goes live. We build these scenarios woth DataMesh frequenrly