Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Limit Import data for last 2 days

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

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Oracle

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous,

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


        Regards,
        Lydia