+14
i have source excel file that it includes first name and second name and id for each name
and another excel file that includes first name and second name at the same cell how could i merge to get id for each name although ometimes the second name repeated
+40Option 1:
Use an attribute splitter (,) on the second spreadsheet to separate the Name into First name, second name.
Option 2:
Use an attributeCreator to concatenate the first spreadsheet names as @value(second name),@value(First name)
In either case you would then use an FeatureMerger/FeatureJoiner to assign the ID to the second spread sheet.
+14Option 1:
Use an attribute splitter (,) on the second spreadsheet to separate the Name into First name, second name.
Option 2:
Use an attributeCreator to concatenate the first spreadsheet names as @value(second name),@value(First name)
In either case you would then use an FeatureMerger/FeatureJoiner to assign the ID to the second spread sheet.
Thanks for ur solution ,I will use it but I was thinking ,how could I use test name at second sheet ,if it contains the first name and second name so do merge .
Do we have method for contains method also.but ur solution looks easier ,just want to learn more .Thanks
+62Option 1:
Use an attribute splitter (,) on the second spreadsheet to separate the Name into First name, second name.
Option 2:
Use an attributeCreator to concatenate the first spreadsheet names as @value(second name),@value(First name)
In either case you would then use an FeatureMerger/FeatureJoiner to assign the ID to the second spread sheet.
I would go for option 2, to avoid potential issues with double names.
+40I would go for option 2, to avoid potential issues with double names.
I was thinking option 1 to avoid issues like second name,firstname not matching second name, firstname (note the space).
+62I was thinking option 1 to avoid issues like second name,firstname not matching second name, firstname (note the space).
Good point. Probably a good idea to cast everything to lowercase and maybe even take out all the spaces. Although depending on the language that can be risky.
