npm package: @itentialopensource/iap-data-manipulation
Description: IAP Transformation Projects for Data Manipulation
Author: Itential
Latest version: 1.0.8-2023.2.1

# IAP - Data Manipulation

## Overview

This Transformation Project contains several transformation examples that are used for data manipulation in Itential Automation Platform (IAP)


## Transformations


<table>
  <thead>
    <tr>
      <th>Name</th>
      <th>Overview</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Aggregate Functions for Arrays - IAP.md' target='_blank'>Aggregate Functions for Arrays - IAP</a></td>
      <td>Run a set of mathematical aggregate functions on an array of numbers</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Allocate a Pair of Numbers - IAP.md' target='_blank'>Allocate a Pair of Numbers - IAP</a></td>
      <td>Find the first available consecutive pair of numbers from an array of already allocated integers given a starting integer and an ending integer</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Allocate One Number - IAP.md' target='_blank'>Allocate One Number - IAP</a></td>
      <td>Find the first available number from an array of already allocated integers given a starting integer and an ending integer</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Chunk Array - IAP.md' target='_blank'>Chunk Array - IAP</a></td>
      <td>Split an array into a smaller sized groups given a desired chunk size</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Clear Empty Keys - IAP.md' target='_blank'>Clear Empty Keys - IAP</a></td>
      <td>Clear empty keys from a JSON</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Convert CSV to JSON - IAP.md' target='_blank'>Convert CSV to JSON - IAP</a></td>
      <td>Convert CSV into JSON</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Convert String to Special Cases - IAP.md' target='_blank'>Convert String to Special Cases - IAP</a></td>
      <td>Convert string to special cases including camelCase, PascalCase, kebab-case, and snake_case</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Filter Array of Objects by Key Value Pair - IAP.md' target='_blank'>Filter Array of Objects by Key Value Pair - IAP</a></td>
      <td>Filter array of objects by key value pair</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Generate Random Integer Within Range - IAP.md' target='_blank'>Generate Random Integer Within Range - IAP</a></td>
      <td>Generate a random integer within a range</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Get Random Element From Array - IAP.md' target='_blank'>Get Random Element From Array - IAP</a></td>
      <td>Get a random element from array</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Get Value From JSON Pointer - IAP.md' target='_blank'>Get Value From JSON Pointer - IAP</a></td>
      <td>Get a value from an object using JSON Pointer</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Group Records by Property - IAP.md' target='_blank'>Group Records by Property - IAP</a></td>
      <td>Group records by a property</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Implement Set Operations on Arrays - IAP.md' target='_blank'>Implement Set Operations on Arrays - IAP</a></td>
      <td>Implement set operations on 2 arrays including union, intersection, set difference and symmetric difference</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Parse Number - IAP.md' target='_blank'>Parse Number - IAP</a></td>
      <td>Convert strings and strings within objects to numbers</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Remove Duplicates From Array of Arrays or Objects - IAP.md' target='_blank'>Remove Duplicates From Array of Arrays or Objects - IAP</a></td>
      <td>Remove duplicates from an array of objects or array of arrays</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Remove Duplicates From Array of Primitives - IAP.md' target='_blank'>Remove Duplicates From Array of Primitives - IAP</a></td>
      <td>Remove duplicates from an array of primitives</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Remove Element From Array by Index - IAP.md' target='_blank'>Remove Element From Array by Index - IAP</a></td>
      <td>Remove an element from an array by index</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Remove Element From Array by Value - IAP.md' target='_blank'>Remove Element From Array by Value - IAP</a></td>
      <td>Remove an element from an array by a value</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Separate Array of Objects by Key Value Pair - IAP.md' target='_blank'>Separate Array of Objects by Key Value Pair - IAP</a></td>
      <td>Separate an array of objects by a key value pair</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Split String into Array by Regex or Separator - IAP.md' target='_blank'>Split String into Array by Regex or Separator - IAP</a></td>
      <td>Split a string into an array by regex or another string</td>
    </tr>    <tr>
      <td><a href='https://gitlab.com/itentialopensource/pre-built-automations/iap-data-manipulation/-/blob/release/2023.2/documentation/Transpose Record by Creating Arrays for Each Property Within Groups - IAP.md' target='_blank'>Transpose Record by Creating Arrays for Each Property Within Groups - IAP</a></td>
      <td>Transpose the record by creating arrays for each property within the groups</td>
    </tr>
  </tbody>
</table>


## External Dependencies

No external dependencies required to run this Transformation Project.

## Adapters

No adapters required to run this Transformation Project.