Resolved: What to do when the text format or language of the intended web is different?
If the text format was different or in a different language, I would not be able to join the two tables because there is no common key between the two tables.
In this situation, should I change the format of the table rows one by one?
What to do when the text format or language of the intended web is different?
You solution will not work because you don't have such currencies in the fact Internet Sales data. We can only connect tables on common keys in this case will be currency code. We need to have the exact same currencies/currency names inside the currency conversion table otherwise the join will not work. Please use a page that contains currencies in English.