Alteryx Join tool
- 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
Team,
I have an interface that sends the data to workflow. The interface has four options. Each option has a different process and connects to the pricing workflow to create a quote. I use the join tool to connect all four processes to the pricing workflow. Only one process will have data every time, and the other three will have no data. In this case, the join is not working as expected, and the workflow stopped.
Is there a way to ignore the empty processes and let Join continue with the data it has? Please help.
Regards,
Alwin
- Labels:
- Join
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @allwynbazil,
I would recommend using the UNION tool instead. You can then use the data cleansing tool afterwards to remove the resulting null columns:
Hope this helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @FinnCharlton . By mistake, I mentioned Join. I used Union. However the issue is same. The data is not going through the Union and the workflow stopped there.
regards,
Alwin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@allwynbazilHow many records are going into the union, and how many are coming out? None?
Also, do you get any errors upon running?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It depends on the option the user selects from the interface. I am not getting any errors but the workflow stops there.
Regards,
Alwin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @allwynbazil, it's hard to help without some more specifics. Can you open your flow, go to Interface Designer, go to test view, select one of the options and press "Open Debug". You can then investigate what is happening with that union tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for checking Finn. Currently am passing the input data from text input tool to fix the issues. If works fine I can connect to Interface.
The results window is not showing anything regarding the union.
The data flows through Formula tool and it is not going through the Union.
Regards,
Alwin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@allwynbazil That final picture is the Input #1 - which is the join tool not the formula tool. What does the Input #2 look like?
Try adding a browse tool directly after the union. Is there still no output?
If there is no output in the browse tool, can you send me a screenshot of the union tool configuration?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Edit: was talking nonsense ignore
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No data in the Browse tool.
The input #2 from formula tool which has data and input#1 is empty.
Union tool config below.
Regards,
Alwin
