Documentation

List Compare & Validation Utility

Overview

List Compare & Validation Utility is an OutSystems O11 extension that compares two text lists and provides both summary and detailed comparison results. It helps developers validate data consistency, identify missing records, detect duplicates, and compare lists from different sources such as Excel files, APIs, databases, SAP integrations, and user inputs.

Features

• Compare two text lists
• Detect matching and non-matching values
• Ignore case differences
• Ignore leading and trailing spaces
• Ignore empty values
• Compare lists regardless of order
• Ignore duplicate values
• Return detailed comparison information
• Return summary statistics

Action

CompareTextLists

Compares two text lists and returns comparison results.

Input Parameters

ListA

Type:

TextItem List

First list to compare.

ListB

Type:

TextItem List

Second list to compare.

IgnoreCase

Type:

Boolean

Default:

True

Treats:

ABC = abc

TrimSpaces

Type:

Boolean

Default:

True

Treats:

" ABC " = "ABC"

IgnoreEmpty

Type:

Boolean

Default:

True

Ignores blank values.

IgnoreOrder

Type:

Boolean

Default:

True

Treats:

A1,A2,A3

as equal to

A3,A1,A2

IgnoreDuplicates

Type:

Boolean

Default:

False

Treats:

A1,A1,A2

as equal to

A1,A2

when enabled.

Output Parameters

Result

Structure containing comparison summary.

Fields

Details

List containing item-level comparison information.

Fields

How to Use

Step 1

Create two variables:

ListA
ListB

Type:

TextItem List

Step 2

Populate the lists.

Example:

ListA

A1
A2
A3

ListB

A1
A2
A3

Step 3

Call:

CompareTextLists

Parameters:

ListA = ListA
ListB = ListB

IgnoreCase = True
TrimSpaces = True
IgnoreEmpty = True
IgnoreOrder = True
IgnoreDuplicates = False

Step 4

Read Result output.

Example:

Result.IsEqual = True
Result.ListA_Count = 3
Result.ListB_Count = 3
Result.CommonCount = 3
Result.OnlyInListA_Count = 0
Result.OnlyInListB_Count = 0

Step 5

Display Details in a table.

Example: