Rank: Newbie
Joined: 8/26/2019
Posts: 2
|
Hi
I am new to mapforce and I have run into a bit of a blocker for me.
I am mapping 2 flat files into one xml and in one of the flat files I need to split out the contents of "employedas" to separate elements in the XML depending on the contents.
See this: https://www.dropbox.com/s/1ix046aafgwsc7e/mapforce.JPG?dl=0
The "employedas" field can contain either "academic", "honorary", "student" or "visiting" and this must be mapped to the correct element under "OrganisationAssociations" which are "honoraryOrganisationAssociation", "StaffOrganisationAssociation" etc. etc.
The data like "FTE", "startdate", "enddate" are acutally underlying data to each "OrganisationAssociation" and must follow the correct OrganisationAssociation - and only the correct one.
Please also note that "personID" in the second file must match the "personID" in the first file so that the data is distributed correctly.
I am pretty sure this can be accomplished in mapforce, but I can seem to figure out how :-(
Any help is much appreciated
*Edit: One option is of course to split up my input files to 4 separate files (one for "academic", one for "honorary" etc), but I'd rather not do that.
|
Rank: Advanced Member
Joined: 9/9/2005
Posts: 483
Location: AT
|
Hi,
On the face of it you just need to filter the source data according to the criteria you mention:
https://www.altova.com/manual/Mapforce/mapforceenterprise/mff_filter.htm
Have you tried this approach? If so and the problem persists please upload (as a zip archive) all the files involved, or contact Technical Support via the Support Forum
|
