Forum Discussion
Can you manually insert row data in a custom column?
Hi Anonymous
My idea is that we can create an additional table in Power Query Editor to work like a dictionary table. You can also use a CSV file or any other data source you like to store the dictionary data. It would be like below, defining pairs of fake IDs and actual values in other two tables that should be joined.
Fake ID Name 1 aa 2 bb 3 cc 4 dd 5 ee Then we can add a custom column to each table to look up and fill in the corresponding Fake ID value from the dictionary table. This can be done automatically with Power Query.
Another workaround is that with this dictionary table, you can create relationships between this dictionary table and each of two tables. Then these two tables actually have a relationship with one another because dictionary table works like a bridge table between them.
Hope this helps.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Community SupportHi Anonymous
My idea is that we can create an additional table in Power Query Editor to work like a dictionary table. You can also use a CSV file or any other data source you like to store the dictionary data. It would be like below, defining pairs of fake IDs and actual values in other two tables that should be joined.
| Fake ID | Name |
| 1 | aa |
| 2 | bb |
| 3 | cc |
| 4 | dd |
| 5 | ee |
Then we can add a custom column to each table to look up and fill in the corresponding Fake ID value from the dictionary table. This can be done automatically with Power Query.
Another workaround is that with this dictionary table, you can create relationships between this dictionary table and each of two tables. Then these two tables actually have a relationship with one another because dictionary table works like a bridge table between them.
Hope this helps.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.