[CLOSED] [Thank you]Recursive (Self-Join) in .MAS file?
Can this be done within the master file (.mas)? I only suggest a recursive join, but other techniques may return the desired results.
EXAMPLE: The file hold 3 fields ID, IDNAME and MASTERID. The MASTERID is the 'parent' of the individual ID. I'd like to develop a MASTERNAME which is the IDNAME when MASTERID eq ID.
ID IDNAME MASTERID MASTERNAME (VIRTUAL) 10 SMITH COMPANY 10 SMITH COMPANY 11 SMITH OF NY 10 SMITH COMPANY 12 SMITH OF NJ 10 SMITH COMPANY
20 JONES INTL 20 JONES INTL 21 FRANK'S 20 JONES INTL
Not a problem in a .fex
Things that make you go hmmmmm.This message has been edited. Last edited by: WF8Developer,
create a clustered join, and rename segments and fields as needed.
August 12, 2013, 10:33 AM
WF8Developer
j.gross-
If I understand correctly, we would need at least two .MAS files? Customer and Customer1 that reference the same table. In Customer there would be join statment with a CRFILE=Customer1.
The preference would be to make that happen in 1 .Mas file.
My apology for not making that clear from the get-go.