topic Re: Replace Null Value Dynamically in Alteryx Designer Desktop Discussions

Replace Null Value Dynamically

sgaryali — Tue, 24 Jan 2023 18:16:56 GMT

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.

Re: Replace Null Value Dynamically

ShankerV — Tue, 24 Jan 2023 18:25:44 GMT

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

Re: Replace Null Value Dynamically

ShankerV — Tue, 24 Jan 2023 18:26:06 GMT

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

Re: Replace Null Value Dynamically

ShankerV — Tue, 24 Jan 2023 18:26:35 GMT

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