The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 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
"Concatenating text fields over a time period"
Contributor I
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
Cheers!
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
would be concatenated into a single one:
date_time | text
-----------------------------------
01/16/2011 23:09:34 | "foo foo"
01/16/2011 10:05:25 | "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.
date_time | text
-----------------------------------
01/16/2011 00:00:00 | "foo foo bar bar"
Cheers!
Tagged:
0
Answers
Look at this process: http://www.myexperiment.org/workflows/1568.html
I think it's doing almost what you want to do.
RicharD.