Lennart Johansen

Simon, thanks a lot! I was finally able to get your example work. and also my previous example works fine.

Hello, I would like to treat multiple csv-files as partitions of one single table, but I'm struggling to make it work. I receive monthly updates of sales data files (e.g. sales-2020_09.csv, sales-2020_10.csv, ...), each file looking like this example data (including header): Region,Country,Item Type,Sales Channel,Order Priority,Order Date,Order ID,Ship Date,Units Sold,Unit Price,Unit Cost,Total Revenue,Total Cost,Total Profit Central America and the Caribbean,Antigua and Barbuda ,Baby Food,Online,M,12/20/2013,957081544,1/11/2014,552,255.28,159.42,140914.56,87999.84,52914.72...