Problem with external lookups
Altair EmployeeI have a problem that I've been fighting. I feel like I'm missing a very simple step but don't know what it is...So, here goes.
I have a model that is pulling in 2 external lookups. Both are working fine. However, they pull the same kind of data and I ultimately need to combine the results into one column. There is no situation where the lookups will pull data into both lookups - its either one or the other but I ultimately need one column.
I've tried to change the fields to numeric and use formulas to pull them together. I've tried to make them character and use formulas to pull them together. Nothing seems to work. I can get an "if" formula to pull in one or the other but not both.
Example"
Field 1 Field 2 Requested results
3788 3788
95743 95743
12345 12345
etc.
Help?
Thanks for all your ideas!
Kathi
You will need to import both columns but if you are certain that it will be one or the other, one of the easiest things to do would be to concatenate the two columns with a formula field (if they are character fields):
trim([Field 1] + [Field 2])
If they are numeric:
[Field 1] + [Field 2]