The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options

"Concatenating text fields over a time period"

kamajikamaji Member Posts: 2 Contributor I
edited May 2019 in Help
Hi all,
I've examples from a database with two attributes- a 'data_time' and a 'text'. I'm trying to aggregate all examples from the same day into a single example, so what I want to do is concatenate their text fields and set the Time field to the beginning of the day (actually i'd like to be more general and do it over any period, but the day will do for now!)

For example, the two examples

date_time            | text
-----------------------------------
01/16/2011 23:09:34  | "foo foo"
01/16/2011 10:05:25  | "bar bar"
would be concatenated into a single one:

date_time            | text
-----------------------------------
01/16/2011 00:00:00  | "foo foo bar bar"
I'm also turning the examples into word vectors with "Process Documents from Data", so I think I can use the Aggregate operator after that, but I can't figure out how.

Cheers!

Answers

Sign In or Register to comment.