Hi
I have a requirement where I need to filter incoming data based on Date i.e there is a column Process_timestamp(data type: Time stamp), I need records where Date(Process_timestamp)=current date - 1 day
What would be the syntax in the where clause in filter stage
Any help is appreciated.
Regards
Om Prakash
Filter Stage
Moderators: chulett, rschirm, roy
Filter Stage
Hi Om
What exactly is the problem you are facing? Is it that you are unable to findout how to get the current date in the where clause or something else?
Regards
Ashwin
What exactly is the problem you are facing? Is it that you are unable to findout how to get the current date in the where clause or something else?
Regards
Ashwin
Filter Stage
I am not sure ![Sad :(](./images/smilies/icon_sad.gif)
May be you can try using CurrentDate(). If it works let us know.
Ashwin
![Sad :(](./images/smilies/icon_sad.gif)
May be you can try using CurrentDate(). If it works let us know.
Ashwin
Hi,
I have used the below code in the "Where Clause"
When run geting the below Fatel error:
I have used the below code in the "Where Clause"
Code: Select all
TimestampToDate(Process_timestamp)=DateFromJulianDay(JulianDayFromDate(CurrentDate())-1)
Code: Select all
Filter_36: Parse error: Expected comparison, 'between', or 'like' operator, got: "("
Parse error: Expected boolean operator (and, or) got: "Process_timestamp".
Yes, Thats what I'm doing now generating two new columns in the transformer stage for current date - 1 day and converting timestamp to date in another and comparing it in filterstage.
OR
I can filter it inside the transformer it self and I dont need a filter stage.
But what I thought was Filter stage should be exhaustive enough to handle complex filters , otherwise the very purpose of having a filter stage fails !
OR
I can filter it inside the transformer it self and I dont need a filter stage.
But what I thought was Filter stage should be exhaustive enough to handle complex filters , otherwise the very purpose of having a filter stage fails !