Hi,

We have a requirement in the report to display a concatenated stirng of PERSON_IDs(say P_ID).
This I am generating in DEFINE. P_ID is based on ISSUE_ID(say I_ID) and AUTHER_ID(A_ID).

The data is something like : --

P_ID I_ID A_ID
---- ----- -----
P1 800 1
P2 800 1
P2 800 3

The code I've return is

DEFINE HOLD_DUMMY
P_ID_STRING/A1000V = IF (I_ID EQ LAST I_ID) AND (P_ID NE LAST P_ID) THEN LAST P_ID_STRING|(P_ID||'@ ; ') ELSE P_ID||'@ ; ';
END

The result I am getting is : P2@;

Expected result : P1@;P2@;

Please let me know if you have any solution.

Thanks.

This message has been edited. Last edited by: Kerry,

Try:

P_ID_STRING/A1000V = IF (I_ID NE LAST I_ID) OR (P_ID NE LAST P_ID) THEN P_ID||'@ ; ' ELSE LAST P_ID_STRING|(P_ID||'@ ; ');

Using the CAR file:

  
-* File lalita01.fex
TABLE FILE CAR
PRINT CAR SEATS
BY COUNTRY
ON TABLE HOLD
END
DEFINE FILE HOLD
C_STRING/A1000V = IF (COUNTRY NE LAST COUNTRY) THEN CAR || '@;'
                  ELSE IF (CAR NE LAST CAR) THEN LAST C_STRING | (CAR || '@;') ELSE LAST C_STRING;
END
TABLE FILE HOLD
PRINT CAR COUNTRY SEATS C_STRING
END

Hi Danny -- you logic worked perfectly. Thanks a lot !!

Using LAST within a define requires that the input file is in the exact sort order that your code logic requires. If this is not the case then you would be better served doing the new field via a COMPUTE within you code.

T

Tony,

Very true!

quote:

Very true!

Thanks Danny, that's why I mentioned it

T

quote:

Using LAST within a define requires that the input file is in the exact sort order that your code logic requires. If this is not the case then you would be better served doing the new field via a COMPUTE within you code.

Very true indeed! Lalita, just keep in mind that, if you use the COMPUTE approach, you'll be using a PRINT verb and *not* a SUM, otherwise it won't work as you might expect.