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. Total Votes:24