Combine two rows
Posted: Sat Nov 19, 2022 1:43 am
Hello everyone, I'm extremely new at this, my knowledge in Easytrieve is close to 0. However, I'm trying to learn, and part of the assignment is to transform a report from this:
--------------------------------------------------------------------------
OPER-NAME/
OPER-ID LOC DB AUTH TC DUAL VERIFY OP DATE/TIME ADDED
AUTH LEVEL TYP DATE/TIME LAST MAINT
-------------------------------------------------------------------------
FUDD, ELMER
A1B6374 01 02 N 09/23/2022 14:08:13
09/23/2022 14:08:13
BUNNY, BUGS
A1B8924 01 02 N 09/23/2022 14:09:00
09/23/2022 14:09:00
TRUMP, DONALD
A1B9847 01 02 N 05/11/2021 15:36:03
05/11/2021 15:36:03
to this:
---------------------------------------------------------------------------------------------------------------
OPER-NAME OPER-ID LOC DB AUTH TC DUAL VERIFY OP DATE/TIME ADDED DATE/TIME LAST MAINT
AUTH LEVEL TYP
--------------------------------------------------------------------------------------------------------------
FUDD, ELMER A1B6374 01 02 N 09/23/2022 14:08:13 09/23/2022 14:08:13
BUNNY, BUGS A1B8924 01 02 N 09/23/2022 14:09:00 09/23/2022 14:09:00
TRUMP, DONALD A1B9847 01 02 N 05/11/2021 15:36:03 05/11/2021 15:36:03
My question here is, how can I 'combine' two rows into one using Easytrieve?
Thank you.
- Guillermo Pérez
--------------------------------------------------------------------------
OPER-NAME/
OPER-ID LOC DB AUTH TC DUAL VERIFY OP DATE/TIME ADDED
AUTH LEVEL TYP DATE/TIME LAST MAINT
-------------------------------------------------------------------------
FUDD, ELMER
A1B6374 01 02 N 09/23/2022 14:08:13
09/23/2022 14:08:13
BUNNY, BUGS
A1B8924 01 02 N 09/23/2022 14:09:00
09/23/2022 14:09:00
TRUMP, DONALD
A1B9847 01 02 N 05/11/2021 15:36:03
05/11/2021 15:36:03
to this:
---------------------------------------------------------------------------------------------------------------
OPER-NAME OPER-ID LOC DB AUTH TC DUAL VERIFY OP DATE/TIME ADDED DATE/TIME LAST MAINT
AUTH LEVEL TYP
--------------------------------------------------------------------------------------------------------------
FUDD, ELMER A1B6374 01 02 N 09/23/2022 14:08:13 09/23/2022 14:08:13
BUNNY, BUGS A1B8924 01 02 N 09/23/2022 14:09:00 09/23/2022 14:09:00
TRUMP, DONALD A1B9847 01 02 N 05/11/2021 15:36:03 05/11/2021 15:36:03
My question here is, how can I 'combine' two rows into one using Easytrieve?
Thank you.
- Guillermo Pérez