I'm pretty sure the course didn't teach how to pull a column from another table, only merge
I managed a way, but how should I be doing this?
sorry, I am not sure I understand your question. Inside this lesson there is no need to pull columns from other tables. At the end of the lesson we are doing a demo by selecting several columns into a table visual
Hi Dimitar, my question is about the assignment steps.
The step 6 says "On the Orders table you need to add a column that represents the currency for each country, the only column that you need is “ISO Code” from “Currency Country” (which function are you going to use?)."
How should I add a column with currencies code in Orders table if I don't pull from another?
Please re-watch the video about merging queries from Power Query.
You can get the column from other table using the Merge Queries.