Issue - items on one side are not visible to choose in Join tool

gregx

This is weird, I added Join tool and on the left I have data coming from db and it's correct.

I want to add some manual input and use Join tool, for this I used Text Input.

However, data from right anchor (Text Input) is not visible, so I can't make the join.

I tried to run the workflow and then tried to make Join, but it's still not visible for Alteryx.

Like the right side doesn't exist.

Any ideas why it's not working?

Attached screenshots. Version: 2020.4.5.12471

Workflow

Developer

Join

Accepted answers

All comments

binu_acs

@gregx The join should show records if you run the workflow. Can you close the designer desktop and open a new instance and try again?

gregx

@binu_acs I wrote I ran it.

Also I restarted it 5 times.

The join configuration should is available before run. Otherwise, how could you set it?

binu_acs

@gregx @The issue you are facing for only this workflow or other workflow as well?

gregx

@binu_acs so far only in this one.

binu_acs

@gregx That is strange, can you create a new workflow and see the issue still there or not ?

gregx

@binu_acs I tried to copy everything to new workflow, sometimes it worked, sometimes not.

It's really strange, also I re-installed Alteryx, but the results are the same.

I think there is an issue in the Alteryx software.

I've made dozens workflows like this, but only this one is causing this issue.

FrederikE

Hey @gregx,

One thing you could do is investigate if there is a problem with the generation of the .yxmd-file.

You can open the .xml behind the workflow (e.g. with Notepad++) and compare if it is shown correctly. If not, your Alteryx version has a problem with generating the workflow itself.

There you could also configure your Join by hand if it doesn't work in Designer (ofc that is annoying af).

This is a very basic join (from the sample workflow):

binu_acs

@gregx There is also a possibility that the data has some invalid characters, which might cause the join not to work, can you make sure the data is clean?

suby

Can you upload as yxzp file .

gregx

Even with the simplest data (a,b,c,d...) it couldn't work. Probably the Alteryx does not work well.
Sometimes I could copy & paste tools to new workflow and it was working for few runs, but always after few runs something happened and it stopped working.

Anyway, I had to rewrite it in VBA, cause it's not acceptable for business purposes that something sometimes work and sometimes not.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703