| jalfano |
| Member |
|
| NY |
|
|
| None Specified |
|
| Tuesday, October 5, 2010 |
| Thursday, April 26, 2018 11:35:41 AM |
15
[0.08% of all post / 0.00 posts per day] |
|
I have another issue with vertical tabs, this time instead of tokenizing on them I want to just flat out replace them with a space character. I am trying to use Replace or Translate and using \x0B as the string to replace but it doesn't seem to be working.
Mapforce seems to be translating this value into  when it goes into the XML file. Later on the next step that XML file's values go into another flat file and this crashes Mapforce.
Can someone tell me how I can filter out the vertical tab from the original flat file?
|
Island,
Thank you for that example. I actually found another way to do it too so I'll share in case anyone else would like to know.
I was able to use a tokenize-regexp function with \x0B as the string constant input to the pattern. This is the hex code for vertical tab. I then had to send that information to a separate XML file.
Either works.
Thank you!
|
I have a field that contains single characters delimited by the Vertical Tab character (hex 0B). What is the best way to parse this data out?
Examples would be:
W
W(vt)B
W(vt)B(vt)I
This is flat file data for a race field that will be split out into multiple races per record.
Thank you
|
I have two flat files (a contact file and an address file) and I need to merge data from the contact and address file into one flat file using the contact's ID field which exists in both files.
I looked at the MergeMultipleFiles.mfd and MergeMultipleFiles_List.mfd and I don't think those solve my problem.
The only way I was thinking I could do this is to create an intermediate XML file with a child element for the addresses and do a node filter by matching the contact ID from both files and filtering the rows of the address file to the child address element in the XML file. In this case it's a 1:1 relationship so once that's done I could map the data from the XML file back out to the original destination flat file.
Does that sound right? Any better suggestions?
Thanks,
John
|
kkspb, it looks like that would work for one field at a time but does it work for multiple fields?
Say I have a home address with Address, city, state, zip fields and a mailing address with Address, City, State, Zip fields. If the mailing address fields are blank (say the address line 1 field is blank) then use the entire group of home address fields.
Do I have to load these into an intermediate file and do node level operations on it?
|
I am also having similar performance issues with large files when I join / filter data. I have some files that take 1-5 hours to map and the files are only 1-2 MB in size. The mapping is going from flat file to XML.
Can someone give any general hints on avoiding these situations like the one jayeagar describes above?
Thanks,
John
|
Say we have the following two files
File1: PersonID | PersonFirstName | PersonLastName | PersonAddress1 | PersonCity | PersonState | PersonZip
File2: PersonID | ContactID | ContactFirstName | ContactLastName | ContactAddress1 | ContactCity | ContactState | ContactZip
I have a function that accepts Address1, City, State, Zip and maps it to an address in the output file. So the person's address fields get mapped to their address record and the contact's address fields get mapped to their address record. However, if the contact's address1 field is blank, I want to use the person's address fields.
How do I do the logic for this?
Thanks!
|
I found another solution which seems to be working, so I'll post in case anyone else has this issue.
If you go into the properties of the source there is a checkbox that says "Treat empty fields as absent" which is checked by default. When I uncheck that box the elements now appear without having to map them as empties.
|
I'm using XML as my destination and it seems that sometimes certain elements are excluded from the generated XML. I'm thinking this may be occurring because there is no data for that record but I have to do more research.
My question is, is there any way to always force creation of an element if it's in your target xsd?
Thanks!
|
I got a copy working based on the example provided above. Thank you so much for your help!
Looks like we'll be getting the enterprise version :)
|
|
