Format text to integer


#1

I want to join data from two different sources. In both tables the first column contains the same type of IDs, but in table A it’s formated as integer, in table B it’s formated as text.

How do I change the format of the column in table B from text to integer so that the inner join works?


#2

you can use the data pipeline prior to joining to cast the column from table B to an integer. You can edit the column and in the custom formula section use the cast function from SQLite:

CAST("column name" as integer)

let me know if you have any questions!


#3

Great, thanks a lot for the quick help!