🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

"Concatenating text fields over a time period"

User: "kamaji"
New Altair Community Member
Updated by Jocelyn
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!

Find more posts tagged with

Sort by:
1 - 1 of 11