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 am trying to create a process that would update a cross-reference table daily. I have a query that finds the initial set of IDs and a few dimensions and creates a table. Next day, I would like to retrieve the IDs that have not been retrieved previously and append it to the same table that was created. What are some options that follows best practices?
It depends on how the workflow is configured. But I think if what you mean is you want to add records from new data to an existing table that were not previously there, you would use an output data tool and configure the output options to: "Update: Insert if new"
This is one way to accomplish what you want if I understand correctly.