Magic ETL formula Help

ozarkram

Hi All,

I am trying to use the following transformation for joining but I am getting an error...Can you please help!

CAST(`DEALER_NO` as varchar(8)).. I am getting the following error...

Syntax error in expression at character 20 on line 1 : cast (dealer_no) as varchar())

Thanks,

Arun

GrantSmith

Have you tried using an alter column tile to change your data type to a string before your formula?

GrantSmith

Have you tried using an alter column tile to change your data type to a string before your formula?

ozarkram

Hi @GrantSmith !...Thank you so much for your response!..Yes I haven't used it before...Yes its useful..