Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Replace Null Value Dynamically

sgaryali
8 - Asteroid

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.

3 REPLIES 3
ShankerV
17 - Castor

Hi @sgaryali 

 

Please find the expected output.

 

ShankerV_0-1674584387301.png

 

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
17 - Castor

Hi @sgaryali 

 

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

As Multi Field formula is used.

 

ShankerV_0-1674584484816.png

 

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
17 - Castor

Hi @sgaryali 

 

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

 

ShankerV_0-1674584684258.png

 

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

Labels
Top Solution Authors