Hi.
We have a problem with customer data and how to present this data.
Users insert data into one table. For each CUSTOMER_ID they insert new record, not as an update of the first record with the same CUSTOMER_ID. That is how they did it from the start.
Data looks like:
Now they want to get same CUSTOMER_ID records as one record. It must show them as one record. Similar to one updated record. If one record has STATE value 3, this value must be shown and ID of this record.
Something like:
SUBMISSION_DATE as listagg would be good, but not necessarily.
Could this be done or should we create new table with one CUSTOMER_ID record and do update on each new record with the same CUSTOMER_ID. Now there are around 110k records in the table.
Thanks.
BR,
Dip