I'm working on a report where rather similar data from two different data sources needs to be compared, namely a list of master filenames and fields on our WF server compared to a list of the same on our WF client.
Some fields are only relevant on the server (such as database names and schema names), while other fields are only relevant on the client (such as the EDA connection used).

So I have two sets of fields with often the same field names, from different sources, that I want to combine into one data source.

I think MATCH FILE is the most appropriate tool to merge these, but because almost all field names are the same between the two data sources I need some way to distinguish them from each other in the result. I was already prefixing almost every field name to that effect, but then it struck me:

Wouldn't it be infinitely convenient to be able to write those identically named unmatched fields into separate segments?

Is that possible at the moment? If so, how to do that? If not, wouldn't that be a good feature to have?

As an example of what I'm dealing with, I currently have this code:

MATCH
FILE MASTERS_remote
PRINT
	APPNAME			AS RAPPNAME
	MASTERFILE		AS RMASTERFILE
	MASTERCREATDT	AS RMASTERCREATDT
	PHNAME			AS RPHNAME

	CREATDATE		AS TBLCREATEDATE
	CATTIME			AS TBLCREATETIME
	RECLENGTH		AS TBLRECLENGTH
	TBTYPE
	SCHEMANAME
	TABLENAME
	REALNAME

	KEYCOLUMNS		AS RKEYCOLUMNS
	COLTYPE			AS RCOLTYPE
	LENGTH			AS RLENGTH
	SCALE			AS RSCALE
	NULLS			AS RNULLS
	REMARKS			AS RREMARKS
	TITLE			AS RTITLE
	LABEL			AS RLABEL
	ALIAS			AS RALIAS
	HELPMESSAGE		AS RHELPMESSAGE
	LONGDESC		AS RLONGDESC
	REMARKS			AS RREMARKS

	USAGE			AS RUSAGE
	ACTUAL			AS RACTUAL
	SKEYS			AS RSKEYS
	KEYSEQ			AS RKEYSEQ
	DEFINE			AS RDEFINE

BY MASTERNAME
BY SEGNAME
BY COLNO
BY FIELDNAME
RUN
FILE MASTERS_local
PRINT
	APPNAME			AS LAPPNAME
	MASTERFILE		AS LMASTERFILE
	MASTERCREATDT	AS LMASTERCREATDT
	PHNAME			AS LPHNAME

	SERVER

	KEYCOLUMNS		AS LKEYCOLUMNS
	COLTYPE			AS LCOLTYPE
	LENGTH			AS LLENGTH
	SCALE			AS LSCALE
	NULLS			AS LNULLS
	REMARKS			AS LREMARKS
	TITLE			AS LTITLE
	LABEL			AS LLABEL
	ALIAS			AS LALIAS
	HELPMESSAGE		AS LHELPMESSAGE
	LONGDESC		AS LLONGDESC
	REMARKS			AS LREMARKS

	USAGE			AS LUSAGE
	ACTUAL			AS LACTUAL
	SKEYS			AS LSKEYS
	KEYSEQ			AS LKEYSEQ
	DEFINE			AS LDEFINE

BY MASTERNAME
BY SEGNAME
BY COLNO
BY FIELDNAME
AFTER MATCH HOLD OLD-OR-NEW
END
-RUN

As you can see, having to prefix all those fields is a bit of a chore...

This message has been edited. Last edited by: Kerry,

Hi Wep5622,

From our technicals: Please open a case with Customer Support Services for assistance. The phone number is 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry