Magic ETL formula Help

ozarkram · 2022-06-01T14:50:52+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Magic ETL

Formulas

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

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

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