Bavian |
Newbie |
|
|
|
|
None Specified |
|
Monday, August 26, 2019 |
Monday, August 26, 2019 11:39:26 AM |
2 [0.01% of all post / 0.00 posts per day] |
|
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.
|
|