Configure Select Records Tool

Question

Hi there,

When using the Select Records Tool, I was wondering if there were other ways to populate the record numbers that I wanted to isolate, aside from just hard coding them when I configure the tool.

Is there any way to use the Record ID tools or perhaps some other tool or variable values to configure the record numbers with the Select Records Tool, besides just typing them from the keyboard?

Thanks in advance for your help!

Mike

mkeiffer · Answer

@Yoshiro_Fujimori Thank you so much for taking the time to post this answer.  This was very helpful!

Mike

Yoshiro_Fujimori · Answer

@mkeiffer ,

It depends on your reason why you want to avoid "hard coding".

If the rows you want to select can be defined by logic, you can simply use a Filter tool.

For example, the two tools below returns the same output.

If there is no way to determine which rows to select by logic and you want to decide it ad hoc basis,

you would be better off putting the line numbers in Select Record tool.

Of if you want to decide which rows to select every time, you may want to build it as an APP instead of Workflow.

gaoa · Answer

@mkeiffer I see. It seems only numbers can be typed in to the Select Records tool. I'm curious to see if anyone else has any ideas! It surely would be great if functions/fields/conditional statements can be typed in so the tool becomes more dynamic.

Select Records Tool | Alteryx Help