Limit Import data for last 2 days

[srlabhe123]

Hi All,

I have 4 tables which are joined with each other on base of keys.

Niw I want to limit the import of all the tables to retrieve data only for last 2 days, please note I dont want to import data and then filter rather while importing only it should filter the records only for last 2 days based on the base of date field.

Thanks

[v-yuezhe-msft]

@srlabhe123,

What is your data source? If you are connecting to SQL Server database, you are able to write T-SQL statement to limit import data for last 2 days.

Regards,
Lydia

[srlabhe123]

Oracle

[v-yuezhe-msft]

@srlabhe123,

You can write SQL statements to limit data to last 2 days when you import data.


Regards,
Lydia