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.
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.
Last edited: