Filtering Global Sales from Different Layouts Directly
Filtering Global Sales from Different Layouts Directly (FilteringGlobalSales)
This App demonstrate how simple FlexETL can be configured to extract data from different layouts with filtering data across multiple filters.
CalcRule File: FilteringGlobalSales.xlsx
Below, the CalcRule file contains 3 different sheets using the ETL module & the Conditional Action module:-
Compute Column: Using mapping function to map exchange rate plus Multiply function to calculate Base Amount.
Select Data
Product: Smart TV
Unit Price: %And(>=10000,<15000)
Brand: Adorable,Gorgeous
Filtering Results
Demo Data: There are 20 Excel Workbook, All Layouts are Different
