Subscription

RSS Feeds List RSS Feeds List

Top Developers


Patryk Szczypien
Created the CurrentTimestamp function

Proud Sponsor of

DataMap Repository

Main Repository Page

feed-icon-32x32.gif RSS

feed-icon-32x32.gif RSS

Order By : ID | File Title | Downloads | Updated Date



Join by LongText fields or fields with different data types
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.
stars/5.gifTotal Votes:24
Updated:
about 2 years ago
Downloads: 23
Comments: 0
Views: 8188
Try It/Edit It
28.32 Kb


Search for Datamaps     Publish and Share a DataMap
 
  Terms and Conditions Privacy Policy Contact Info Comments and Suggestions ETL News