Dear Forum Members
I have a look up table which i have created and i have two join keys i.e. “SupplierID” and “ProductNo”.
When we do look up join do we have to have the same name column to do the join? I am having an issue as I have different datasets and within same dataset the column header can be “SupplierNumber” instead of "SupplierID and “ProductNumber” instead of “ProductNo” - is this acceptable?
Please if you can kindly advise