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!
Solved! Go to Solution.
Hi @Eneida33
You can use formula like this to fill blanks values.
IF IsEmpty([Value]) THEN 0 ELSE [Value] ENDIF
Hope this helps : )
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!
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).
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.
Hi @Eneida33
Please check the join tool select window they might be deselected. They should appear here.
Hope this helps : )
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.