This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm looking to add records to an alteryx database each week from another data source. One way would be to create a new yxdb each week, but that doesn't seem like the best option. Is there a way to simply append the new records each week? I'm new to Alteryx, so I might be missing something very simple.
If you are looking to overwrite the same file, it's not that hard. You would use an Input to bring in the yxdb file you already have, another one to bring in your new data, and then a Union tool to bring them together (I'm assuming the column format stays the same). Once together, add a Block Until Done tool and then an Output tool. Point the Output tool to your original yxdb file and choose yes to overwrite. This will read in your data and combine it and once that's completely done, will then write back to the original yxdb without any errors. Since this is overwriting your original data, I would suggest adding a Browse tool under the Input tools so that you have the ability to save the original data back out. Hope this helps!
Bringing in the data, unioning, blocking til done, and re-outputting can take hours if you have a huge YXDB. The functionality to simply append would be very beneficial to some of us. I actually posted an idea for this back in 2013. Go to "https://alteryx-community.force.com/AlteryxIdeaDetail?id=087E00000004rEVIAY" and vote for it. Maybe if it gets enough votes, they'll add the functionality.