Alteryx Join tool

[allwynbazil]

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

[FinnCharlton]

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

[allwynbazil]

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

[FinnCharlton]

@allwynbazilHow many records are going into the union, and how many are coming out? None?

Also, do you get any errors upon running?

[allwynbazil]

It depends on the option the user selects from the interface. I am not getting any errors but the workflow stops there.

Regards,

Alwin

[FinnCharlton]

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.

[allwynbazil]

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

[FinnCharlton]

@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?

[OllieClarke]

Edit: was talking nonsense ignore

[allwynbazil]

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