Join not producing result

[Chirag77]

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,

[mceleavey · Accepted solution]

Hi @Chirag77 ,

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

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

And these are the resulting joins:

I hope this helps,

M.

[Chirag77]

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

[mceleavey]