I am working on a DB2 database, and I need to compare data from an excel worksheet. The excel worksheet contains the account number along with other information. I am able to join the account number from the excel worksheet with the account field from one of the tables in the DB2 database...
I have the following formula created
if ((onLastRecord) or Next({data.acctnum}) <>
({data.acctnum})) Then 'STOP' Else ' '
Which puts the the word "STOP" at the end of account number line.
an example of how this works is:
12345
12345
12345
12345
12345 STOP (stop tag is @ the end of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.