Join Data Issue

[britknip]

I am trying to join the two attached data sets. I need to join the following:

Date to Date

Prod Cat to Product Category

ChannelName to Type

I can join the first two just fine but am having a problem when joining ChannelName to Type. I have changed the data type and messed around with the data quite a bit but cannot figure out what the issue is. Can anyone help?!

[MarqueeCrew · Accepted solution]

@britknip,

The JOIN tool is case sensitive.  You should create a new TYPE field (TYPE_forJOIN) and use the formula:

UPPERCASE(TYPE)

then it should join better.

You can simply update the TYPE field without adding a new column if you don't mind changing the case of the TYPE field.

Cheers,

Mark

[britknip]

Thank you, this worked perfect!