function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
LibraLibra 

Data Loader and multiple external ids

Can you perform an upsert where you find a match on two external ids instead of just one?  For example, update this record where account number = account number and group number = group number?
SuperfellSuperfell
No, it has to be on a single field.
LibraLibra
That's too bad.  Thank you for the information.  I guess I'll make a feature request.
benjasikbenjasik
One options is to combine the fields into a composite field.

You can even use a workflow field update to concatenate two fields together on a save and store that in a new custom field value.
LibraLibra
I am probably going to do that.  Thanks!
gireeshzgireeshz
Wow - the workflow field update idea is genius.  Well thought sir! 

Could you explain 'combine the fields into a composite field'.  Can I do this in map (sdl) file?  For example, for a source file with 3 'Street' fields:

Street1\nStreet2\nStreet3=ShippingStreet


Is there a way ??

thanks