Scenario: We need to implement a filter by date in the Extract
where date_column > to_date('2016-01-01','yyyy-mm-dd')
Simple...
Implemented:
TABLE source_table,
COLS (list of columns),
FILTER (@COMPUTE (@DATE('JUL', 'YYYY-MM-DD', date_column) >= @DATE('JUL', 'YYYY-MM-DD', '2016-01-01')) > 0)
Should be easier, if someone found another option please feedback.
No comments:
Post a Comment