Join not producing result

Hi,

First of all thank you in advance. Happy to be part of Amazing community.

I am on training wheel with Alteryx completely new picking up for the person left the job. I am finding interesting tool.

I have vulnerability report trying to join based on severity column and add the remediation target column to each line item base severity entry. Not producing any results. So far I have tried changing data type for severity on both did not help.

This is smaller workflow of larger automation process.

Any insight will be helpful.

Thank you for your time.

Best,

Report - Copy.xlsx

New Workflow1.yxmd

Join

Accepted answers

mceleavey

Hi @Chirag77 ,

This is due to the case sensitive nature of the join.

I've attached a data cleansing tool to the Report input:

Screenshot 2025-06-12 144946.jpg

And these are the resulting joins:

Screenshot 2025-06-12 144946.jpg

I hope this helps,

All comments

mceleavey

Hi @Chirag77 ,

This is due to the case sensitive nature of the join.

I've attached a data cleansing tool to the Report input:

Screenshot 2025-06-12 144946.jpg

And these are the resulting joins:

Screenshot 2025-06-12 144946.jpg

I hope this helps,

Chirag77

Excellent Thank you for your quick response M. That did the trick. Appreciate you.

mceleavey

no problem.gif

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703