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.
Back when I used to do more coding, some of the ORMs had the ability to return back to you a natively generated primary key for new rows created; this could be really useful in situations wherein you wanted / needed to create a parent / child relationship or needed to pass the value back to another process for some reason.
As it stands now, the mechanism to achieve this in Alteryx is kind of clunky; all I have been able to figure out is the following:
1) Block until done 1.
1a) Create parent record. Hopefully it has an identifying characteristic that can be attached to.
2) Block until done 2.
2a) Use a dynamic select to go get the parent record and get the id generated by the database.
3) Block until done 3.
3a) Append your primary key found in 2a. Create your children records.
I mean it works. But it is clunky, not graceful, and does not give you any control over the transaction, though that is kind of a more complicated feature request.