To Number: Lost Information in Conversion - Warning Message

[jalizmaldonado]

Hi, I hope all is well. Does anyone know what this warning message is trying to tell me? I'm not sure if miswrote my formula or if that way I did it caused discrepancies.

[christine_assaad]

Hi @jalizmaldonado 

Would you please elaborate on why do you need the tonumber() function?

This is used if a number is coming thru as text but you want it to be numeric. Looking at the logs, the values contain letters. Hope this helps. Cheers!

[messi007]

@jalizmaldonado,

Could you share a sample data of the data as well 🙂

It will help us to investigate.

Regards,

[jalizmaldonado]

Hi, attached are the data sets I used in my workflow.

Thanks so much!

[messi007]

@jalizmaldonado,

The problem is that you are trying to apply number operation to a string

I deselected the fields above from the Transpose tool and updated the formula.

Could you test and let me know:

Attached the workflow

Regards,