if null value in dynamic date columns, then fill with values based on specific conditions

[Jules22]

I have a workflow that creates a table like below:

Now based on Leave count, I need to change the value of [Null] values.

if leave count = 0, then [Null] values should be updated as "Not updated"
if leave count =1,2,or more, then [Null] values need to check the below table

then update [Null] values as "Leave" according to respective dates below

For Example:
1. Deepika is absent on 2024-09-16, so in the above table update [Null] for 2024-09-16 column as "Leave" rest all as "Not Updated"
2. Pranil is absent on 2024-09-16 and 2024-09-17 so update [Null]s for 2024-09-16 and 2024-09-17  columns as "Leave" and fro rest column as "Not Updated"




Note: These dates are dynamic, so keeping the column name in formula tool might not help.

Any suggestion or POC would be appreciated. Thanks!!

[binuacs]

@Jules22 one way of doing this

[Garrett_Stoker · Accepted solution]

I may have overcomplicated this, but here's what I would do:

Mixing numerical and text fields may get tricky further down the line, but it works this way. You shouldn't need to worry about the dates/columns being dynamic since the Multi-Field is set to accept new columns and Transpose will take on anything.