String fields can only be joined to other string fields - error

[Fescobar]

Hello Everyone,

I am in need of assistance.  I know that the fields in my data set all match (Numbers); however, when I bring the data into Alteryx, I get the join error stated above.

Left 

Right

Any assistance will be appreciated.

FEscobar

[Qiu]

@Fescobar 
you BPN field is in Numeric Type (Double). I think that is the cause.

[Qiu · Accepted solution]

@Fescobar 
I converted the Joint Key Fields to V-String with a Select Tool

Is it suppose that no output from Joint?

[Fescobar]

Thank you for relying...

Yes, these will end up on a joined document.  In the final I’m expecting to have left/right/join sheets on a spreadsheet.

I’ll plug in your workflow and give it a whirl.

Thank you!!

Fausto

[Qiu · Accepted solution]

@Fescobar 
Appreciate if you would mark it as acceptable if you find it useful.

[Fescobar]

Thank you so much!

[Qiu · Accepted solution]

@Fescobar 
Thank you also for the accept mark.