GROUP BY - Two fields only, but keeping the rest in FINAL table.

[#1]

Hi,

Anyone have an ide how to exclude gouping by "Sender" in the below, but keeping it in the FINAL table somehow?

In other words I need to group by "Date" and "OriginalTime" only. But keeping "Sender" in the final table.

Pls see below and find attached sample files.

Thanks in advance,

Olle 

[#2]

Anyone pls?

[prieper]

Not quite clear, what you require.

You may insert a

CONCAT(DISTINCT Sender)

to have all possible senders one field - they might lateron be separated by SUBFIELD.

Alternatively to have the table with Sender and both dates linked to the datatable on the dates-field.

HTH Peter

[maxgro]

from what I understand sometimes you have more sender for one row

see attachment

[#5]

Hi Peter,

My problem is that I need to keep the "Sender" field in my FINAL table.

However my data should NOT be Grouped by "Sender". Only by Date and OriginalTime.

In the set up above, all of the fields in the final table is required to be part of the grouping in INITIAL table, else an error message will occur.

Kind Regards,

Olle