topic Re: Querying SQL inside formula tool in Alteryx Designer Desktop Discussions

Querying SQL inside formula tool

Pickaxe — Sat, 30 Oct 2021 08:52:38 GMT

Im trying to add my "SQL query" into the "formula tool" with data type as V_Wstring, and then pass it to the database tool ( dynamic input in db ) with a source link to execute the query.

But my issue is - the sql code becomes "truncated"

I have tried string,v_string but none of them worked

I.e. when executed after few words the code ends with three dots ,example: [select isg ...]

IS THERE ANY WAS TO PASS THE ENTIRE QUERY WITHOUT IT GETTING TRUNCATED.

Kindly advice. Stuck on it for days.

Re: Querying SQL inside formula tool

atcodedog05 — Sat, 30 Oct 2021 08:55:47 GMT

Hi @Pickaxe

If you created the SQL query using formula tool it should be able to accommodate a large length. Even though it might look truncated it will still have the data try running and checking it once.

Re: Querying SQL inside formula tool

atcodedog05 — Sat, 30 Oct 2021 09:03:14 GMT

Hi @Pickaxe

To view the complete data you can add a browse tool after running the workflow open a browse window by selecting below options.

In the new window double click on your data cell to see the full existing data

Hope this helps : )

Re: Querying SQL inside formula tool

Pickaxe — Wed, 03 Nov 2021 10:30:01 GMT

Thanks a lot will try it out😊