How to add a query to the Formula tool?

[s92ma1988]

The goal is to add a column, which is a result of a select statement, to an existing input data set.

For example, how to add column D to below existing columns A,B,C where column D is a result of a select statement that uses column A B C in the where clause?

To be specific, now we have column A B C as our input dataset, 

A B C

1 2 3

given above, how to add column D = select GBQ_D from a good big query table where, for each row, GBQ_A in that table = A, GBQ_B in that table = B, and GBQ_C in that table = C

Let me know if you need further clarification. Thanks so much for your help.

[binuacs]

@s92ma1988 are you looking something like this?

[s92ma1988]

Thanks, do you have an example that actually runs which demonstrates the correct use of the select statements in the formula tool. Thank you

[s92ma1988]

Thanks, do you have an example that actually runs which demonstrates the correct use of the select statements in the formula tool. Thank you

[s92ma1988]

@binuacs Thanks, do you have an example that actually runs which demonstrates the correct use of the select statements in the formula tool. Thank you

@binuacs

[binuacs]

@s92ma1988 I don't have any example , but a simple SELECT statement can be written like below in the formula tool

[s92ma1988]

@binuacs

Thank you again, but this column added here is the statement itself, what's needed is the select result of that statement run. 

[atcodedog05]

Hi @s92ma1988 

The formula tool itself cannot run a query you may want to pass the query into the dynamic input tool and get results.

Refer to this video from 8:16 minute https://www.youtube.com/watch?v=ELfKYatOJZM 

Hope this helps : )