Alteryx on Collection workflow

[frankylam]

hi All, i would like to create a workflow as per below table but not workable. Could someone help me?

[OTrieger]

@frankylam 
Ok, what are the requirements to get it done?
This can be done, but to finalize the logics need to understand the requirements for this job