Using Infoassist - is there anyway to do something similar to a union. I can create 3 seperate hold files with last name - they are all based off of different criteria - I want to do a simple union of the last names to get a list

[Rebecca Owens]

Using Infoassist - is there anyway to do something similar to a union. I can create 3 seperate hold files with last name - they are all based off of different criteria - I want to do a simple union of the last names to get a list

[Martin Yergeau]

Perform MORE if all 3 files have same number of fields, same field's name & format

TABLE FILE ASUM FIELD2BY FIELD1ON TABLE HOLD AS MRGFILEMOREFILE BMOREFILE CEND-RUN

See page 1230 : Universal Concatenation : TIBCO FOCUS® Creating Reports Release 9.1.0