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


Thanks,

Arun

Best Answer

  • GrantSmith
    GrantSmith Coach
    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!**

Answers

  • GrantSmith
    GrantSmith Coach
    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!**
  • Hi @GrantSmith !...Thank you so much for your response!..Yes I haven't used it before...Yes its useful..