Replace Null Value Dynamically

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.

Sample Input Fiile.csv

Workflow

Accepted answers

ShankerV

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

Replace Null Value Dynamically.yxmd

All comments

ShankerV

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

Replace Null Value Dynamically.yxmd

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

Sample Input Fiile.csv

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703