Convert Number to Text value

markdg — Mon, 28 Feb 2022 18:35:00 GMT

Hi everyone,

The source data from the POS for the product SKU it is alphanumeric.

Some skus are in the format ####.####

So here's an issue I am running into. Even though I have used the following in the data loader

Tag "sku_updated" with 'text';

I am still getting #,####.##

Basically, it is turning the ####.#### into a number and rounding to two decimal places. Not what I want.

Any suggestions?

Re: Convert Number to Text value

Digvijay_Singh — Mon, 28 Feb 2022 19:56:03 GMT

you may want to transform field with the text() function -