Forum Discussion
Import Excels from folder: Filter first, combine after - or combine first, filter after
Hi, I'm importing xlsx from a folder. Each xlsx has 3 sheets. My question is: What is "better"? A) Open binaries, open tables, filter for correct sheet (Companies, Answers, Filters) - and combi...
Never click on that "binary" link when you have selected a folder unless you will never need to change it. The path gets hardcoded in the M code. You can change it, but it is annoying.
Combine, then do the changes. For 3 files it really doesn't matter, but if you need a 4th file, the combine first will scale automatically. Or a 40th file.
edhans
Community Champion
Community ChampionNever click on that "binary" link when you have selected a folder unless you will never need to change it. The path gets hardcoded in the M code. You can change it, but it is annoying.
Combine, then do the changes. For 3 files it really doesn't matter, but if you need a 4th file, the combine first will scale automatically. Or a 40th file.