indb questions

I tried to look at the "tool mastery" link but the indb tools aren't listed there. How do i know, if i have a lot of indb and static input tools, in a workflow, when do you "stop until done" and when not? i'm still getting used to a gui programming language where all the inputs are started at the same time and I'm joining data from both static and indb inputs. does Alteryx read in the entire static input, in the case of joining a static and an indb input, then try to join them? if i have inputs that need to start later on from the initial inputs/joins, how do tell them to not start until the previous ones are one? thanks

In Database

In-Database

Accepted answers

KOBoyle

There are a couple of training videos that might have the information that you are looking for.

https://community.alteryx.com/t5/Live-Training/Live-Training-Your-First-In-Database-Workflow/m-p/148073#M278

https://community.alteryx.com/t5/Live-Training/Live-Training-In-Database-Tools/m-p/45285#M42

All comments

KOBoyle

There are a couple of training videos that might have the information that you are looking for.

https://community.alteryx.com/t5/Live-Training/Live-Training-Your-First-In-Database-Workflow/m-p/148073#M278

https://community.alteryx.com/t5/Live-Training/Live-Training-In-Database-Tools/m-p/45285#M42

danrh

It is my understanding that Alteryx optimizes how to input and join data, so for the most part you don't need to worry about sequencing. Could you provide a use-case where you need some Inputs to be read before/after others? Most of the time you shouldn't try to deal with these situations and should just let Alteryx do its thing.

As a side note, Block Until Done is a highly misunderstood tool. What it does is gather the records from upstream, then release them all at once, first through stream 1, then stream 2, then stream 3. Note that it does NOT wait until all the tools downstream in stream 1 finish prior to releasing stream 2 --- it waits until the last record leaves via stream 1. So take that into consideration before using it. I find the tool to be of most use when I'm reading from a table (Input) and then writing to that same table (Output). I want the read to completely finish before I write, so a Block Until Done achieves that as it gathers the data, allowing the Input to finish, and then releases it to be written back to the table.

Anyway, hope this sheds some light. Feel free to reply back with an example to see if we can't help out.

becki

thanks!

becki

I have two inputs, right now one is a indb and one is static. bring them in, join them, take the output of the join (the joined part) , edit some fields in that output, add a field called "nameplate" then join to a new input (looking for engine codes based on name plate and other stuff), manipulate that joined data, changing fields, then join to another static input, etc.. does that make sense?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703