simple tables join

[chronis69]

hi

I want to do a simple join of 3 tables who dont share any common field they just have the same number of rows. I have 

table 1=

a

b

c

table 2 = 

1

2

3

I want a table that would be 

table 3=

a,1

b,2

c,3

Im tagled with all the left/first inner/outer joins... I just want the two "stitched" together.

thnx

C

[MFelix · Accepted solution]

Hi @chronis69,

Assuming that they both are in the sorting you need.

Add an index colum to each table then make merge based on index of both tables.

[chronis69]

@MFelix 

thanks. do I have to create a relationship between the index columns?

thnx

C

[MFelix]

Hi @chronis69 ,

This should be done in the query editor using the merge option:

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data#combine-queries