Hello, I hope everyone is well.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Eneida33
You can use formula like this to fill blanks values.
IF IsEmpty([Value]) THEN 0 ELSE [Value] ENDIF
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Eneida33
Please check the join tool select window they might be deselected. They should appear here.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.