Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat for MongoDB, Navicat for Snowflake, Navicat Premium

 

You may use one of these two options:

  • Lookup Table (Substitution): It maps each original value to a fixed substitute. You can match exact values or Regular Expressions, and choose whether matching is case sensitive or an exact match.
  • Hashing: It turns each value into a fixed-length string with MD5, SHA-1 or SHA-256. Use it for identifiers that still need to be joined or compared.

Have more questions?
Submit Ticket