Sql Query structure

[praneshsapmm]

Dear Community,

I have requirement which is more related to SQL rather Alteryx .

Item	Col1	Col2	Col3	Col4	Col5
A	1	11	22	33	44
B	2	11	22	33	44
C	3	11	22	33	44
D	4	11	22	33	44
A	1	2	3	4	5
B	1	2	1	1	1

Database contains huge data as shown above . Each columns 'Item' must run through the workflow as shown below (just an example but is more complicated) . When i try to pull the data all at a time , my system hangs and takes a lot of time to process . 

Is there a way to process the data by 'item' at a time . Complete the workflow and process the next 'Item' . 

My workflow is shown here : 

Any help is appreciated.  

[praneshsapmm]

Hi@grazitti_sapna 

Great help !!

My output is as shown :

Iam not sure why selected value is not picked up by filter . May be iam missing something .

[grazitti_sapna]

Hi @praneshsapmm,

Pass a default value in your filter and try and replace that value from the list.

I have passed default as A and from the expression [Item]="A", I will be replacing A with the input values.

[praneshsapmm]

Hi@grazitti_sapna ,

Yes i did . 

Here i have made 'SW1' as default but passing 'SW2' as input from list box prompt . 

Ideally 'SW2' must be returned . But output is 'SW1' .

[grazitti_sapna]

Hi @praneshsapmm,

can you please try and feed the Value "SW2" using text input tool and control parameter as I had done in the Workflow attached earlier?

Can you make use of the workflow and macro that I had shared by just changing the values A B C with values such as SW1, SW2 etc.

In the screenshots that you have attached, I can see that you have not selected the filter tool but you have just edited the value in replace string and changed that with SW2. Ideally it should be like as shown below:

1) Initially while just selecting the filter in update value it will show the whole filter condition in "Replace a Specific String"

2) Now for my use case, I don't want to replace the whole filter condition, rather I only want to replace A with incoming value through control parameter from text input, which is B in my case. So I have omitted [Item]="" from the Replace a Specific string and I have only kept A there. But if you see the screenshot the selection for filter in the update values is a must.

If it still not works for you, I suggest you change the values in the workflow that was shared by me earlier and see if it is working for your use case.

[praneshsapmm]

Hi@grazitti_sapna 

I had modified the way you mentioned . It is working .. workflow attached . 

But when i replace control parameter with List box and try to send the value , it does not work. 

Thanks

[grazitti_sapna]

Hi @praneshsapmm,

You can make your workflow using control parameter also. It will run the number of iterations based on the items in the text input. Suppose if you have 7 items in the text input then the macro will run 7 times using control parameter also.

[praneshsapmm]

Hi@grazitti_sapna 

Thankyou for all the responses .

One more question . I would like to connect this workflow to database and i like to process data only by values entered by user . 

For example : If user wants to process only SW1 and not rest , how this could be handled . Next time SW2 and so on , without altering the filter everytime .

Thanks.

[grazitti_sapna · Accepted solution]

Hi @praneshsapmm,

You can make use of the check box tool to achieve this.

Go through the links given below:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Check-Box/ta-p/60724

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-Check-Box-to-control-if-a-value-...

I hope it helps.

[praneshsapmm]

Hi ,

Iam running this batch macro to pass and filter the value based on check box input . 

But this fails to return values , when multiple boxes are checked in . Can someone let me how to pass through multiple values .

Thanks

[praneshsapmm]

Hi @grazitti_sapna 

Can you let me know is it possible to pass multiple values through list box and update tool .

It fails for me when i do it .

Thanks.