Forum Discussion
Dont Understand the Join
If you want to join them row by row (you have same 128 rows in each table and 8 rows per ID) you can add index to both tables and create such join with INDEX column.
Ok, thank you :).
Is there a way to add this column exactly as it is, which would be easy in Excel, but seems impossible here.
Hello Schreckofant ,
You can make relationships with data modelling instead of join in Power Query. However, you made data modelling and put the columns that are product_ıd, user ıd and reference ıd, you will get same results. You need more column that needs to be joined.
Kind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |