Join Kind Option is not seen

[Amulya_Jain]

Hello All!,

Can anybody please help me out to find out why I am unable to find the "Join Kind" option in the Merge Window?
Is there any plug ins I need to enable??

I'm working with 2016 MSO 16.0.4622.1001(64 bit)

[#2]

@Amulya_Jain 

I don't see on screenshort you selected the columns on which to match.

[#3]

Hi @Sergei Baklan ,

Even after taking the common columns in both the tables I do not get an option of Join Kind :(

[#4]

@Amulya_Jain 

I see. Same issue is mentioned here https://www.excelguru.ca/blog/2015/12/16/merge-tables-using-outer-joins-in-power-query/ in comments for older build of 2016. I'm not sure which one it shall be, but did you update on the latest build?

[#5]

@Sergei Baklan ,

Thanks for the info. The excel I'm working on is of 2016 MSO 16.0.4622.1001(64 bit) and funny thing was i I was able to use the Join Kind few days back hence I thought I messed up with the query settings!

[#6]

@Amulya_Jain 

It looks like a bug, have no other ideas.