Hi,

I'm running into an issue with the currency data type conversion with the pipeline tool inside Zoho Analytics.

Basically, when the table is added to the pipeline, the columns with currency data type will be converted to text type. I assume it's because there's a currency symbol in the values. Originally, the currency is Japanese Yen "¥", because that's our local.

I tried various ways to change the data type but they all failed.

- Converting the data type directly to currency results in invalid data.

- Removing "¥" symbol and thousand comma separators, then changing data type to number, then changing data type to currency results in invalid data.

- Removing "¥" symbol and thousand comma separators, then changing data type to number, then saving an output table, then changing the data type to currency in the exported table will work but the currency is Dollar "$" instead of Yen but I couldn't find a way to change that.

Is it something impossible to achieve with the pipeline tool or would that work by creating a query table instead? The pipeline tool is supposed to allow to change the data type in currency but it always give me a 0% match.

Thanks