Forum Discussion
power Query
I would need inputs in desiging of the data model. i have three tables (A,B,C,D) Joining by Shipto ID between A,B,C and D A join with D (Ship to ID) B Join D (Ship to ID) C Join D (Ship ID) A...
Hi Anonymous ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
Anonymous , Did not get it completely. But you can create a concatenated column in both tables and join it
New column like
New key = [Column1] &"-" &[Column2]
How does it work? which table to which table the join should make? how it effect on end results.