Extract Data from System back tables

Hi Community,

I have a question please, I have to many times a day check stock levels in different sites to see if one site can support another's urgent demand. it may be one item or it could be many items, so I have Alteryx WF where i have the input mapped to out system back tables. but i keep having to open the table, then go into the the Visual Query Builder and replace the item i want to check, then close the tables and run the WF

My question is is there a way to enter a item # or list of items into a text box in the WF and for the WF to run on this criteria?.

So I could enter the item / Items directly into the WF without the need to keep opening / closing the back tables?

Pictures of my poor attempt to do this, and how I do it normally

Any help greatly appreciated

TIA,

Karl.

Workflow

Accepted answers

ChrisTX

Here are some interactive lessons on creating Apps:

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%20Analytic%20Apps

All comments

atcodedog05

Hi @Karl_Spratt

Configure the action tool to only replace the key which you want to change

Key you might want to change

Hope this helps : )

Milli Sec.yxmd

ChrisTX

Try the in-DB tools. There isn't much documentation for in-DB tools; you'll need to search the community forum.

You could convert the workflow to an app, with an input parameter that feeds into an in-DB tool.

A few related posts:

Iterative Macros: Live Training: Developer Series
https://community.alteryx.com/t5/Live-Training/In-Database-Processing/ec-p/758874#M72

A few basic questions about in-database tools
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/In-database/td-p/805628

Chris

Karl_Spratt

Hi atcodedog05,

When I open the action box, mine doesn't look like your screen shot, I have removed the Item criteria 47664182001 from the back tables but I don't see where I can enter a new Item number in the Action box and get the WF to use this to only run the query for this item, See below.

Regards,

Karl.

atcodedog05

Hi @Karl_Spratt

Click on plus you see the query in that give it to replace the id 47664182001

Hope this helps : )

Karl_Spratt

Hi atcodedog05

When I expand that + I see this, I tried to hit the replace, the new item # 23390156 with and with ' ' and the WF is still bring back the Item # checked in the back table query.

atcodedog05

Hi @Karl_Spratt

You need to specify same value in the below also. Its the value to be replaced so it will be 47664182001 without quotes

Hope this helps : )

Karl_Spratt

Sorry Man I still can't get this to replace the old Item 47664182001 with the new Item 23390156

When I run it it still shows the old item

Sorry I can't see where it pulls item 23390156 into the WF.

atcodedog05

Hi @Karl_Spratt

Did you try running it as an app and check?

ChrisTX

Here are some interactive lessons on creating Apps:

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%20Analytic%20Apps

Karl_Spratt

Thanks atcodedog05 / Chris,

For your help, I'm doing the interactive learning on creating analytic apps on line so hopefully I will get it 😀

I did pick up a good tip which I used in my WF and is working for me at the moment, I changed the WF to add a txt input box where I can add one /many items then I parse the items to create each item into a row downstream ( seen this in the training)

and it works perfectly, I can enter as many items as I want and it works, no need to open the back table.

I really appreciate your time and help here, I know more today than I did yesterday 😊

Cheers,

Karl

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703