Currency Data Type Issue

Currency Data Type Issue

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
    • Sticky Posts

    • Invitation-Based User Access in Zoho Analytics

      Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security
    • [Webinar] Evolving BI & Analytics in the Age of AI

      Artificial intelligence is redefining how data is collected, analyzed, and leveraged across industries. As businesses strive to become more agile and insight-driven, traditional BI and analytics must transform to meet new demands. AI-first organizations
    • Geo-Powered Retail Intelligence with Zoho Analytics

      In today’s highly competitive retail landscape, data-driven decisions are no longer optional — they’re essential. While businesses collect vast volumes of data across regions, stores, and customer segments, the real value lies in how effectively this
    • Create and save user-specific filter views with Zoho Sheet

      The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file.   Collaborate with user specific filters   Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. If
    • Customer Segmentation using RFM Analysis

      How well do you know your customers? Whether you operate in a B2B or B2C space, chances are that 80% of your business comes from just 20% of your customers (Pareto's Principle). According to a study by Forbes, acquiring new customers costs five times