topic select data only from the last 30 days in Connectivity & Data Prep

select data only from the last 30 days

Anonymous — Tue, 14 Aug 2018 14:14:17 GMT

Dear all

I like to select data only from the last 30 days. It works static, but I like to have this dynamic.

Thanks for your help in advance.

Re: select data only from the last 30 days

petter — Tue, 14 Aug 2018 18:06:53 GMT

Be aware that everything between the SELECT and the following semicolon is interpreted by the SQL source/database. So any logic used in the Where part of the statement would follow the syntax and functions available in the SQL data source.

But you should be able to use $-sign expansion that will be executed before the load script sends the SQL SELECT statement to the source. Maybe like this:

v30DaysAgo = Date( Today(1)-30 , 'YYYYMMDD' );

Select * From ABCD Where abcd >= '$(v30DaysAgo)';

Re: select data only from the last 30 days

Anonymous — Fri, 17 Aug 2018 07:53:30 GMT

Thanks a lot, it works very well.

Re: select data only from the last 30 days

petter — Fri, 17 Aug 2018 08:30:17 GMT

Please mark the question as answered and correct