Who's Online

We have 12 guests and 2 members online

Subscription

RSS Feeds List RSS Feeds List

Top Developers


Patryk Szczypien
Created the CurrentTimestamp function

Proud Sponsor of

Main Repository Page

Join by LongText fields or fields with different data types       >>

Try It / Edit It

DataMap Description: Apatar can?t join data by LongText field values. If you need to join by LongText values or if the fields you are using to join data have different data types, use Transforms between your data sources and Join operation. In Transform go to Edit Output (at the top left-hand corner), click Add from Inputs and change the type of Id field to Text (if you have LongText fields in both tables) or Numeric like in the example if one of the data sources fields is a numeric field. Then go back to Tranform's work area and map the fields.

Updated: about 7 years ago

Created By: Ludmila Radzevich (Ludmila)

File Size: 28.32 Kb

Views: 19425

Downloads: 56

Tags: Join

Rating: stars/5.gifTotal Votes:24

Note: Try It/Edit DataMap requires Apatar Data Mashup installation

 
  Terms and Conditions Privacy Policy Contact Info Comments and Suggestions ETL News