Who's Online

We have 1 guest online


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 8 years ago

Created By: Ludmila Radzevich (Ludmila)

File Size: 28.32 Kb

Views: 20054

Downloads: 94

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