Cross Refence Limit Avoidance
Theory: Limits can be avoided using copy row automations
Test Run today:
Sheet 1 = Site A Items, 7600 rows, imported using Data Shuttle/Merge
Sheet 2 = Site B Items, 7600 rows, imported using Data Shuttle/Merge, multiple columns index matched from Sheet A, changes triggers a copy row to Sheet 3
Sheet 3 = Index match more columns from another dataset, row addition triggers a copy row to Sheet 4, then move the row to a "Garbage" sheet
Sheet 4 = Helper column to identify duplicate rows and move the older one to the "Garbage" sheet.
This seems to be working, Sheet 4 has all the combined information and not a single cross refenced cell, I just need to empty the Garbage sheet on occasion
Is this sound or is it going to come crashing down?
Answers
-
It sounds like it should work so long as you keep your maintenance up and you do not need to worry about the referenced data changing.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives