PowerQuery Merging multiple queries

[SOQLee]

I would like to add 2 new columns to the Main query by merging from each Rate table. The values in the expanded column do not populate down the rows, across all data files (only the rows of 1 data file in the folder), despite having common column, ie. program code, or custom key. The steps I am using in PowerQuery are: merge query, select common column, left outer join.

My workbook query structure is:

Main -- 21,121 rows loaded from data files stored in a folder, program code, customkey

Rate1 -- connection only, table imported to PQuery, 107 rows, program code

Rate2 -- connection only, table imported to PQuery, 181 rows, customkey


Very frustrating, any advice is welcomed. Thank you.

 

[SOQLee]

UPDATE SOLVED. I cleaned up the text in the common columns using TRIM function and that seem to do the trick.

I would like to add 2 new columns to the Main query by merging from each Rate table. The values in the expanded column do not populate down the rows, across all data files (only the rows of 1 data file in the folder), despite having common column, ie. program code, or custom key. The steps I am using in PowerQuery are: merge query, select common column, left outer join.

My workbook query structure is:

Main -- 21,121 rows loaded from data files stored in a folder, program code, customkey

Rate1 -- connection only, table imported to PQuery, 107 rows, program code

Rate2 -- connection only, table imported to PQuery, 181 rows, customkey


Very frustrating, any advice is welcomed. Thank you.