I need a file(say FILE4) whose maximum no. of fields are avaialable in a file(say FILE1) based on record type- 3(record type is a field in FILE1), other fields in the FILE4 are available in FILE1 based on record type-4.
Key field in FILE1 is Account number field.
Please let me know how i can achieve it.
What i feel is that, i can split FILE1 based on record type.
After splitting i will have 2 files say FILE2 and FILE3.
I'll join these 2 files to create FILE4 based on Account number and include the fields which are required from both FILE2 and FILE3.
Please let me know if i am correct, if so please provide me the syntax.
If you have some other approach then do let me know with syntax.