Alteryx Create row based on condition

[AJ106]

Hi 

I have email alert workflow where i send alerts about alteryx workflows status running on server.

My Data looks like below

workflow name	start time	end time	status	error	elapsed time
workflow_A	XXXXX	XXXX	Success	-	XXXX
workflow_B	XXXXX	XXXX	Failed	errorr something	XXXX

I am only taking workflows data of today and send the email alert once daily at some time in morning.

I have a list of workflows(needed for my use case)  that i filter from entire workflow logs from server.  my data set will have entries for only those workflow lets say (for example, 4 workflows)

there are few instances where i might not see entry for some workflows because they are either still running or didnt run for various reasons. but my logs will only show success or failure. if the workflow is running or didnt run i wont have entry for that workflow in the table

if for example today when the email alert is triggered i only have entry for 2 out 4 workflows(that i need) that i need and two of them are either still running or didnt run yet. I want to create a row for the two workflows and say they are in-progress/didnt run. in status column as below 

workflow_name	start time	end time	status	error	elapsed_time
workflow_A	X	X	Success	-	X
workflow_B	X	X	Fail	some error	X
Workflow_C	X	X	In-progress	NA	X
Workflow_D	X	X	In_progress	NA	X

Please Advise 

Thanks

[atcodedog05 · Accepted solution]

Hi @AJ106 

Here is how you can do it. You can have a list of all workflows and you can take outer join of the ones with error and all workflow

Workflow:

Hope this helps : )

[AJ106]

Perfect !

I think this should solve my problem

Appreciate your help

[atcodedog05]

Happy to help : ) @AJ106 

If my response helps please don't forget to mark it as solution.

Cheers and have a nice day!