Hello, I hope everyone is well.

[Eneida33]

                           

 In my workflow I have this fields coming through the right output, are not joining because there is no data.

How could I create fake data. I want the value in these three to come always 0.

Thank you!

[atcodedog05 · Accepted solution]

Hi @Eneida33 

You can use formula like this to fill blanks values.

IF IsEmpty([Value]) THEN 0 ELSE [Value] ENDIF

Hope this helps : )

[Eneida33]

Yes this worked for that part, thank you.

However, in the join tool these three fields are not coming up, because on the left input they do not exist, I created them in the right input. So, how could I make them coming through from the join output without touching the left input?

Thank you!

[atcodedog05]

Hi @Eneida33 

They should be there can you please check join tool select window they should be listed. Fields should be listed even if they are in one of them (L or R).

[Eneida33]

Hi, Yes they are listed in the right output. But I would like them to come through the join output. As now they are not in the rest of the workflow because they  are not coming through the join. Unless if I should use a formula tool after the join tool to include them manually. 

[atcodedog05]

Hi @Eneida33 

Please check the join tool select window they might be deselected. They should appear here.

Hope this helps : )

[Eneida33]

They are listed there. 

I think it has to do with my macro. I will have to check It.

Thank you, you are very helpful as always.