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 have some data I get from Excel form that I clean. I want to insert this into an Oracle table that is already created. I would like to delete any records from the table that fall on a certain date and match a certain ID. After this I want to insert all the data that I cleaned in my flow into the database. Why is this so difficult to find any documentation on this? Is Alteryx trying to hide this from customers?
I have used a batch macro to send the conditions I want to delete on. I also put the original data set through the Batch Macro with no processing so I know the deletes happen first. I then send this original data into output tool to be appended to Oracle Table. I have gotten this to work with Strings only. It seems to freeze now when I have mixed Oracle Datatypes (Date,Number, varchar, etc). I think it is doing this because of datatypes because I only want to insert 60 records in my testing.
You can currently map field names to alteryx variables. Would there be plans in the future to have a table that shows the DataType Mapping where you can select so Alteryx Variables match Databases datatypes?