Hi All,

I have requirement where I have to merge two hold files whcih has different set of columns.

TABLE FILE HLD1
PRINT
COLA
COLB
END
-RUN

TABLE FILE HLD2
PRINT
COLC
END
-RUN


How to bring COLA, COLB and COLC to same hold file?

Regards,
Ramya

This message has been edited. Last edited by: <Kathryn Henning>,

Is there a common field between the two ?

Can you give an example of HLD1, HLD2 data and what you expect out ?

Yeah there are common fields between HLD1 and HLD2. So I can go for join right?

so far I was thinking about appending for which we need equal number of fields and format should be same and that was no he case for me.

Thanks Waz.

Just make sure the fields being joined are the same format.

Also if you are joining two hold files (not FOCUS files with indexes) they needs to be sorted in key field order.

Why not use MATCH?
Easier to use for fixed format hold files than JOIN and more types of combination of the data contents are possible.

Do you want to merge the data or you want to join the data. Since merge do not need any relation but Join needs atleast one. If there is no relation still you need to join, then you need to use CROSS join.

Thanks,
Ram

Or at worst do it this way, the result looks stupid, but it's only for the logic :

TABLE FILE CAR
PRINT COUNTRY
      COMPUTE CAR/A16 = '';
      COMPUTE MODEL/A24 = '';
ON TABLE HOLD AS HLD1
END

TABLE FILE CAR
PRINT COMPUTE COUNTRY /A10 = '';
      CAR
      MODEL
ON TABLE HOLD AS HLD2
END

TABLE FILE HLD1
PRINT COUNTRY
      CAR
      MODEL
MORE
FILE HLD2
END