Book a Demo
A search icon
Data Mapping

Data Mapping Use Cases

Video tutorials of some common data mapping scenarios handled by Adeptia.

Watch Demo Read More

Adeptia Data Mapping Use Cases

Adeptia Connect simplifies data mapping by enabling business users with self-service. By learning from existing data mappings, Adeptia Data Mapper employs artificial intelligence/machine learning to suggest possible connections among data fields between source and target files with varying confidence levels.

It enables business users to handle a multitude of scenarios such as database schema mapping for integration, data cleansing from disparate data stores, data conversion & migration tasks, without relying on expensive IT resources.

Here are some common use cases of Adeptia’s data mapping solution.

How to Create and Manage Maps in Adeptia Connect?

Learn to create maps and manage new as well as existing maps as a part of a transaction set up with Adeptia Connect application.

How to Use If/Then/Else Condition?

Learn how to run a conditional logic (apply if/then/else condition) on one or more source fields in the Adeptia data mapper.

How to Filter Records From Source File?

Watch this video to learn how to use Adeptia’s data mapping mechanism to filter records coming in from the source data file.

How to Do Cross-Reference Using Value Maps?

Learn how to use a value map function within the Adeptia data mapper as a cross-reference function to change the incoming value to another value without writing an extensive if/else condition.

How to Apply Date Format Conversion?

Tap into this video see how to use a date format function to change the format of the incoming date to a different format in the Adeptia data mapper.

How to Apply Substring to Read Partial Value From a Field?

Watch this video to learn how to use a substring function to read only a part of a source data value in the Adeptia data mapper and test the outcomes with data viewer or debugger.

How to Do Drag and Drop and Apply One-to-One Mapping Rules?

See this video to learn how to use one-to-one maps where source fields are mapped with target fields with the help of drag and drop feature of Adeptia data mapper.

How to Merge Two or More Source Fields?

Watch this video to determine ways to merge or concatenate two or more source fields in the Adeptia data mapper.

How to Put a Constant in a Target Field?

In this video, you can learn how to place a constant (a hard coded value) in a target field in the data mapper and test results with data viewer or debugger.

How to Calculate an Aggregate Total on Multiple Source Records?

Tap into this video to learn how to employ an aggregation function (calculate a total on a numeric field) in the Adeptia data mapper.

How to Use Local Variables in If/Then/Else Conditions?

Watch this video to learn how to use local variables in if/else/then condition to parse and cleanse a particular field value like name value on the source file.

How to Use Artificial Intelligence to Automate Data Transformation?

Unlock the power of artificial intelligence to automate data transformation. In this video, you can learn to pull accurate mapping suggestions from Artificial Intelligence Mapping (AIMap) component in the Adeptia application and transform, validate data automatically.

How to Pull Matching or Common Records From Multiple Sources?

Watch this video to learn how to find common or matching records from two sources based on a common key.

How to Remove Duplicate Records?

Watch this video to learn how you can implement handling rules to remove duplicate records from your source file in the data mapper.

How to Configure Database Lookups?

Learn how to query database tables in mapping and pull values and map to target elements.

Load Schemas, Graphical For Each and 1 to 1 Mappings in Data Mapper

Master the art of loading schemas, carrying out a graphical for each, and performing one to one mapping in the data mapper from the expert. Watch this video and discover how a simple drag and drop approach can make this tedious task turn simpler.

Change Views in Adeptia’s Data Mapper

Changing views in the data mapper is a simple solution for resizing and showing or hiding different parts of data mapper. Take a look at this video, a step-by-step guide to business users, and learn how to change views in the data mapper efficiently.

Multidimensional JSON to Canonical Format Conversion in Few Minutes and Clicks

JavaScript Object Notation (JSON) file conversion is a highly common conversion need during customer data onboarding. Adeptia provides powerful, simple, and automated controls to support JSON data transformation in easiest way. It enables business users to extract, normalize, and convert multi-dimensional JSON data into Canonical Format or any other comprehensive format. JSON layout can be successfully remapped to Canonical Format or any other file format without any data skew issues.

In this video, we will show you how Adeptia enables Business users to handle EPOCH Date formatting in and dental tiers formatting needs for specific use cases like:

  • “EE” to 1
  • “EE+SP”  to 2
  • “EE+CH” to 3
  • “FAM” to 4, etc.

Watch this Video to know about our JSON to Canonical Format or JSON to Excel capabilities.

Breakdown Silos, Rapidly Connect Large and Nested Files to Canonical Format

Data conversion need not be cumbersome, time taking, and tedious anymore. Adeptia enables business users to handle large amount of structured & unstructured files and convert them in a comprehensive format.

In this use case, we will map a transaction which has the data of over 10,000 employees including several numeric values, rows columns, and anomalies with another excel file. We will show you how to:

  • Split Plan/Class information from one column into 2
  • Handle incorrect data anomalies (1% of file)
  • Enable passthrough for anomalies with special characters.

Merge EDI 834 Customer Data

In this video, we will show you how to merge multiple EDI 834 files into a single office format. In this example, we will use two separate 834 roaming files — Dental and Vision. Using Adeptia Platform we will merge them into a single record.

Splitting One File Into Two

In this video, We will use Adeptia’s interface to split one file into different outputs. As a part of the exercise, will take the example of a policy data file and split it into two separate files:

  • 1 file with demographic info + Life Policy info
  • 1 file with demographic info + LTD Policy Info

Defining If/Else Condition in a Mapping

Data mapping elements in an input/ output message assembly can be defined with If/ Else (as a specific or derived type) conditions with Adeptia’s Enterprise Class Solution. In this video, we will define If/Else conditions to control the data mapping flow between elements. As an example, we will use salary based If/Else conditions. Here are some things that will be covered in the video:

  • Remap a file from a random layout to standard Canonical Format Layout
  • Employees with the salary of 50k – will be given the values of:
    • 1 for LI Plan
    • 1 for LI Class
    • 50000 for LI CVG
  • Employees with the salary of 1-49,999 will be given the values of:
    • 2 for LI Plan
    • 2 for LI Class
    • 25000 for LI CVG

Random Data File to Common Output Data Onboarding Use Case

In this video, we will show you how to pick up a random data file and map it to an output format. We will pick up an Excel file from source and map it to standard Canonical Format Layout. This use case is applicable to scenarios where a Plan code needs to be replicated into Class Code Field:

  • Value 1 in Plan Code should pass 1 in Class Code
  • Value 2 in Plan Code should pass a 2 in Class Code

XML to Canonical Format Conversion, Automatically in Minutes

Many business systems use Extensible Markup Language (XML) to store data and share it via Internet or corporate networks. It is wide-spread standard, but difficulties arise while converting XML into other formats for data interchange.

In this video, we will show you how to Map Extended Markup Language (XML) format into a common format. As a part of this use case, a Random XML Layout will be successfully remapped to Canonical Format and its information will be used to fill columns. Here are some of the other things which will be covered:

  • Add in Salary Code of A for all employees
  • Remove/ adjust timestamp data, i.e., 2017-10-01(T00:00:00) into 10/1/2017
  • Enable Passsthrough for names with special character, i.e.,”Geslog!Ì”

Learn More About Adeptia Solutions

Check out these great resources to learn more about how Adeptia can help your organization.