Hello,
Here is my contribution to #Preppin Data Challenge (2021 Week 21) with my first use of “Iterate Project” action in order to dynamically read several excel tabs.
Preppin data challenge : https://preppindata.blogspot.com/2021/05/2021-week-21-getting-trolleyed.html
Source Code : Reading Excel File.morph (1.7 KB) Reading Metadata File.morph (12.4 KB)
Sources files : Metadata.xlsx (8.4 KB) PD 2021 Wk 21 Input.xlsx (851.1 KB)
Best regards & hope it helps you
Nicolas Mieszaly