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