I would like to split my rows based on a column with different dates.
and what I want to do is to split the rows which is prior than today(or a given date) and later than today.
I have tried Date & time rule based filter, but what I want is a splitter.
Please kindly share if any other nodes I can try.
Thanks!
Could you share some sample data and also show us what the expected results would be for the sample data, just to make sure we understood what you are trying to do?
Hello Milly_Lin,
I am not sure if I understood your question correctly. Can you update your question with sample values and output ?
From what I understood,
I think you can use “date time variable” node with use execution date option and link it rule engine/string manipulator/column expression where you can append a flag column with the > today logic and with “row filter” node you can get two outputs
Thanks for your reply. the example is like below. If today is 2022/5/20.
I would like to split the rows based on the date and will combined to one table again after several other nodes.
I know the title of the post says “based on Date and Time”, but looking at your sample data, it looks like it depends only on date, so I configured the node to produce a Date value instead of a Date&Time.
By using the execution date&time, it will give the current date. In the event you want to split at some other date, you can specify the date instead of using the execution date&time.
Something like this would do for you:
It’s still 2022-05-19 here, so that’s my current date:
I have the same sample data as you:
And I used this rule in the Rule-based Row Splitter: $Date$ <= $${SDate}$$ => TRUE
where $Date$ is my Date column, and $${SDate}$$ is the variable “Date” holding the current date value.