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.  

[grazitti_sapna]

Hi @praneshsapmm , you might need to run this as analytical app then.

Give this a try and if this helps kindly mark this post as solution.

Thanks.

[praneshsapmm]

Hi @grazitti_sapna ,

Can you send this as .ymxd file . Iam unable to open . Seems iam using a older version.

Thanks.

[grazitti_sapna]

Hi @praneshsapmm , app file cannot be converted to yxmd format but you can open this app in notepad and change the version as per the one you are using I have changed the version to 2019.1.

Thanks.