Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Best way to pull one field from a table multiple times in an information link


Maureen Boyle

Recommended Posts

I have a table with unique employee numbers and names. In my currentinformation link, I am pulling various data fields from two other tables. Now, I would like to update multiple employee name fields/columns to normalize them with the names in this third Employee master table. Right now, the names are coming in from the two main tables but vary due to punctuation, spaces, etc. The employee number is in my current information linkin mulitple fields per row. Obviously Im looking for the most efficient way to do this for processing 6mil records and growing.

Thanks for any assistance you can provide!

Link to comment
Share on other sites

×
×
  • Create New...