How do I correct a data flow that has a "String" error?

kim_barragan0126 Member

October 2024 in Magic ETL

I am getting the below error on a data flow that has been working well for months. How can I fix this?

0

Best Answer

• 

  ColemenWilson Coach

  October 2024 Answer ✓

  Use a formula tile with the following formula:

  REPLACE(REPLACE(Column,'(','-'),')','')*1

  

  If I solved your problem, please select "yes" above

  0

Answers

• 

  ColemenWilson Coach

  October 2024 Answer ✓

  Use a formula tile with the following formula:

  REPLACE(REPLACE(Column,'(','-'),')','')*1

  

  If I solved your problem, please select "yes" above

  0
• 

  kim_barragan0126 Member

  October 2024

  Perfect! Thank you!

  0

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.

Sign In