| shilpasarode |
| Newbie |
|
| SF |
|
|
| None Specified |
|
| Tuesday, August 31, 2010 |
| Tuesday, September 14, 2010 10:21:02 PM |
9
[0.05% of all post / 0.00 posts per day] |
|
vlad wrote:This exactly question has already been answered by island in your previous post. Please do us all a favor and read answers. Use filter. See documentation and CompletePO.mfd sample which comes with MapForce.
I got done now vlad, actually i had read all the posts, i just did not know how to use these filters for muliple fields but now i have figured out.
btw i do not have the CompletePO.mfd, probably because i have the trial version. But anyway i will try to get these samples somehow becaus ei think they will really help. Thanks
|
island wrote:Yes, use a "logical and" if the filter is based upon more than one criteria.
Thanks, understood. I could achieve this in 2 ways. 1> Using filters another 2> Using logical and. I was wondering which one would perform better because my input files are going to be very huge. I guess they both will perform similar.
I have attached my files for reference if someone else wants to look
|
vlad wrote:Click the button right from the worksheet name and uncheck "Show Worksheets by name"
Thanks Vlad, that worked.
|
hi, I have 2 input files company.xls and Users.xls. I want the reuslts in my results output xml file only i companyId and companyName matches between Users.xls and Company.xls. how do i create this mapping ? Should i use logical AND ? I am confused as to which function i should use.
In sql language I want equivalent of
select * from Company c, Users u
where
c.companyid = u.compnayid and c.companyname = u.compnayname.
|
Hi,
I have one more question. In companymaping_ammended.mfd, we have worksheet name as Users. I want the mapping to work even if the input file Users.xls have a different worksheet name, like sheet1. How to achieve this ? The thing is we will get these input files called Users.xlsx from a 70 different client application and we do not want to enforce them to maintain the same worksheet name.
Thanks,
Shilpa
|
island wrote:You need a filterAlso take a look at the merging files section of the documentation. The attached mapping outputs the users in the appropriate company.
Thank island, that mapping helped me understand what i needed to do.
|
vlad wrote:Everything seems to be very simple in your case. What did you try and what didn't work?
Thanks for your reply vlad. It would be of great help if I can get this resolved. I worked on this during the day and i have a slightly different question this time. Hopefully my message is also clear to understand this time.
I have the following files:-
Companies.xlsn -> This excel stores company list. Company id 1 is IBM and Company id 2 is Dell
Users.xlsn -> stores User list, User's are linked with company using CompanyId
company.xsd -> Schema for the output xml
My question this time is how do i link Users to the Company. Like User Shilpa should only come under company id 1 ( which is IBM) and User Hiren should come under company id 2 ( which is dell) Right now with the mapping that i have I am getting each user under each company.
I have attached all the files including project.
|
Hi, I am trying to populate a part of data to my xml from excel file.
My xml xsd schema is as attached and i want to map the <users> from excel sheet to my xml file. How do i do that ? I will have multiple AddCompany nodes and excel has users for each company. Any help will be of great help to me. Thanks in advance.
|
|
