Use an excel table to modify your SQL query If you regularly run queries to any database in your workplace, chances are you have encountered a user request like this: We can use Excel to query the database and get the information requested, but you will have to manually write the WHERE conditions that include […]
Dynamic SQL queries with Excel’s Power Query Read More »
When we connect to a folder to combine all the files, Power Query creates a “Query” called Sample File, which is used as example to process each file, the results will depend on the columns that exist in this file. But what happens when any of the files have missing columns? In the below example,
Combine Files With Slightly Different Columns Read More »
When we connect to a folder to combine all the files, Power Query creates a “Query” called “Sample File”, which is used as example to process each file, the results will depend on the columns that exist in this file. But what happens when any of the files have less columns than others? In the
Power Query Files from Folder: Read More »
Combining files with Power Query is great but what happens when some unformatted files have less columns?
Learn How to Combine Tables With Slightly Different Columns Read More »
