This image shows the SALES table in the Transform editor to convert the CHANNEL_ID column to text to use in the join.