Magic ETL: Avoid loading all the input columns and rows from data vault.

rajpalbajaj

In Magic ETL, to avoid loading all the input columns and rows from the data vault.  

On the Input tile, under “Data Handling Section”  if there could be a provision (refer to attached pdf with screenshot)

1. check box  to select required columns (simple request)  and 
2. text box to add a where clause on each column Or one text box to write the entire where clause (preferred) for all the columns and should be easy to implement and the developer is responsible for correct syntax

(Since tiles can be copied from one etl to another etl, while copying input tiles, it should retain these settings) 

Magic ETL - Input Tile _ Avoid All rows an columns.pdf