Replace Null Value Dynamically

[sgaryali]

Hi 

I want to replace Null values with "-'

Which is easy but the problem is it should be dynamic.

Like right now I have data till 5-jan-2023 but next day I will be having another column 6-Jan-2023 and I don't want to do it manually again.

So next day when I am running workflow it should dynamically take new column into consideration and Replace NULL with "-" for them as well.

I am attaching sample file for reference.

Please let me know if any other clarification is required.

[ShankerV · Accepted solution]

Hi @sgaryali 

Please find the expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @sgaryali 

To answer your specific, It will work dynamically if new columns are also added.

As Multi Field formula is used.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @sgaryali 

Please find the results when it the CSV files with more columns are used in input.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V