Hi everyone!
Currently I want to generate two output if the data is not null. If one of them has no data at True/false, then the anchor that has no data will not proceed and will end at the filter tool.
Eg. in Animal column, it has value of Cat 1, Cat 2, Cat 3, Dog 1, Dog 5.
At filter, it will filter if Animal's value contains Cat, then the True will generate report for Cat, False for Dog.
However, it will not generate for Cat Report thru True anchor if no data regarding Cat since I use analytic apps and user might did not select Cat (Cat 1, Cat 2, Cat 3) in the checkbox.
You might need a macro, with a detour and input of data being number of records, and a condition if 0 then go one way otherwise another. This could also be done with containers.
@Madihah_29 let me know if this helps
Hi @aatalai, much thanks for your response! I really hope that you can provide me the sample workflow. I have no idea on how to do this and not familiar with detour and macro.
@Madihah_29 unfortunately i'm away from alteryx for around a week or so, so if you can wait sure
okay then, I'll wait for you. Lots of thanks @aatalai !
Hi, sorry for disturbing you.
Do you have an example of the solution?
Hi @Madihah_29
Have you tried killing / allowing parts of your flow using control containers?