i have a select query which i use in Dataflow task, as shown below
now i want to consolidate this to one row as shown below. this depends on the condition that, if name and id are equal and then if f1 is "yes" for any one row (name + id combination) the output f1 should be "yes". Same for f2
note: this should not change the underlying table data.
asked Feb 04 '11 at 10:31 AM in Default
group by name, id
answered Feb 04 '11 at 11:15 AM