Data Mapping Use Cases

Video tutorials of some common data mapping  
scenarios handled by Adeptia

 Watch Demo  Read More

 

Adeptia Data Mapper- Video Block - Create and Manage Maps

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. 

Adeptia Data Mapper- Video Block - If Then Else

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.

Adeptia Data Mapper- Video Block - Filter Records

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. 

Adeptia Data Mapper- Video Block - Value Map

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.

Adeptia Data Mapper- Video Block - Date Format

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. 

Adeptia Data Mapper- Video Block - Substring

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.

Adeptia Data Mapper- Video Block - One to one maps

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. 

Adeptia Data Mapper- Video Block - Merge fields

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.

Adeptia Data Mapper- Video Block - Constant

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. 

Adeptia Data Mapper- Video Block - Aggregation

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. 

Adeptia Data Mapper- Video Block - Using Variables

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.

Adeptia Data Mapper- Video Block - AIMap

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.

Adeptia Data Mapper- Video Block - Pull matching

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.

Adeptia Data Mapper- Video Block - Remove Duplicate

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.

Adeptia Data Mapper- Video Block - Database Lookups

How to configure Database lookups?

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

Adeptia Connect - Video Block - Load Schemas

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.

Adeptia Connect - Video Block - Data Mapper

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.

Adeptia Connect - Video Block - JSON to V2

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. 

Adeptia Connect - Video Block - Large File to V2

Breakdown Silos, Rapidly Connect Large & 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. 

 

Adeptia Connect - Video Block - 834 Files to V2

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 & Vision. Using Adeptia Platform we will merge them into a single record.

Adeptia Connect - Video Block - One File to Two V2

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

Adeptia Connect - Video Block - If/Else

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

Adeptia Connect - Video Block - Random Layout to V2

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

Adeptia Connect - Video Block - XML to V2

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!Ì"

Bottom CTA -Gray

 Take the next step in transforming your business data ecosystem.

                                                                             Contact Us         See Demo

Stay in Touch
Subscribe to our blog to get the latest product updates, news, and thought leadership