Adeptia Data Mapping use Cases

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 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 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 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 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 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 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.

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.

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. 

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.

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

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