Data Mapping Use Cases
Video tutorials of some common data mapping
scenarios handled by Adeptia
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.
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!Ì"
AC - Features - Resources
Learn More About Adeptia Solutions
Check out these great resources to learn more about how Adeptia can help your organization.
- White Papers
- White Papers
- White Papers
- White Papers
- Comparison Charts
