Magic ETL formula Help

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())



Best Answer

  • GrantSmith
    GrantSmith Indiana 🥷
    Answer ✓

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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**


  • ozarkram
    ozarkram ⚪️

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