Insert New column if value is missing

Question

Hi All,

Ques:
If Month column does not have "April or May" then a new row with April/May should be added with null values for Value & path column.

Could someone help ?
Thanks inadvance!

atcodedog05 · Answer

Hi @Veni_Padam

Sorry for the delayed response. You can use the join tool and union to have all the months included.

Workflow:

Hope this helps : )

Month (2).yxmd

binu_acs · Answer

@Veni_Padam

Month.yxmd

Veni_Padam · Answer

Hello @atcodedog05 
Apr or May - it should be in different rows but not as a single value "Apr/May"
I just gave the data for reference, but in real case it should check all the months and should populate a new row for each missing month.

And instead of using a separate flow for each month checking, can that be done with a single logic?