Hi, I'm trying to join two data sources but the fields I'm trying to join on are mismatched values; one is string, and the other is number. I would like to write a join calc (example attached) but my workbook is not presenting me with that option (screenshot attached). Please advise best troubleshooting option... any info would help.
you can do the conversion and join. Just go to Header and do Type Conversion and Join