Is it possible to write a multiple queries in single query

[Nagaraju_kanna]

Hi,

Is it possible to write a multiple queries in single query. 

I have written multiple queries in workflow but not working all queries at a time.

Please find the attachments

[Qiu]

@Nagaraju_kanna 
I believe it is possible, but we need to make the name of "RESULT" in your Formula tool to be unique between each other.

You are using the same "RESULT" for each criteria and it will just cause the upper get override by the lower one.

[Nagaraju_kanna]

Thank You.

I new for alteryx, I tried with single query. but it's not working. please find the screen shot.

[atcodedog05]

Hi @Nagaraju_kanna 

Can you please provide the associated input file for the attached workflow and expected output.

[Nagaraju_kanna]

Hi 

Please find the attachment for related file.

[Nagaraju_kanna]

Hi atcodedog05,

Please find the workflow, input file and expected output file.

[atcodedog05]

Hi @Nagaraju_kanna 

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05]

Hi @Nagaraju_kanna 

Please find the updated workflow

Hope this helps : )