Extract Data from System back tables

[Karl_Spratt]

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.  

   

[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 : )

[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 · Accepted solution]

Here are some interactive lessons on creating Apps:

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