Example_Files.zip (70.7 KB)
I am trying to learn how to use loops in EasyMorph. To achieve this, I tried to set up a EasyMorph project in which a simple for loop is used. I also tried look for different sources that explain how this works but it still is not clear to me. Could you please help me with the following application?
*I have 10 base files that each contain 250k rows. These files are called 'Base_file01.xlsx' to 'Base_file10.xlsx'. For sake of ease, I narrowed the amount of rows per Base_file down to 10 rows. Each Base_File contains the following columns: *
1. Article Number
3. Gross price
5. Net price
*I also have four different customers that each obtain their own unique discount. These customers are called customers A, B, C and D. The discount each customer receives can be found in a different file called 'discounts.xlsx'. Each discount per supplier per customer is listed in a column (Discountfactor Customer A, Discountfactor Customer B, and so forth). *
*For each customer, I would like to use the 10 Base_files, add the discount from 'discounts.xlsx' file via the merge from another table' command to generate the 10 unique lists for each customer. *
For example: for customer A, the discount needs to be added from 'Base_file01.xlsx' to 'Base_file10.xlsx' via the 'merge from another table' action. Then, the files 'CustomerA_file01.xlsx' to 'Customer_file10.xlsx' need to be generated by using the for loop. For customer B, C and D a similar approach will be used. Pllease explain how I can use a for-loop to loop over these 10 base files in EasyMorph in such a way I that I can use the 'merge from another table' action in each iteration to generate the unique lists for each customer. So, the output for customer A should be 'CustomerA_file01.xlsx' to 'Customer_file10.xlsx', each containing the 10 products of each corresponding Base_file.
Your time and attention are greatly appreciated.