Integration Studio Core BizApps

Technical reference guide for supported core applications

OneCloud Documentation avatar
58 articles in this collection
Written by OneCloud Documentation
Tabular Transformation

Tabular Transformation Common Issues

Common things you should check for when your Tabular Transformation does not work.
OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Solution Highlight: How to fix the Advanced Query Command dropping of leading zeros

This solution highlight addresses how to fix the issue of Advanced Query dropping leading zeros on fields
OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Tabular Transformation

The OneCloud BizApp for Tabular Transformation enables the preparation of data prior to loading into target systems.
OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Tabular Transformation Command Reference

This BizApp assists with transforming tabular datasets
OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

DBeaver for Advanced Query Testing

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Input File not Found with Advanced Query Command

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Find and Replace is not working with Exact Match. What is going on?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

What is the Smart Filter Rows Command and how do I use it?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

What is the difference between Transform and Pivot?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How to sum values with a dollar sign?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How to Incorporate Multiple "Find and Replace" into a Single Command?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How to filter out the first record of a file?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How to display numbers in their native form?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How to "Find and Replace" a single character (pattern)?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How do I use Advanced Query with spaces in the columns names?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How do I add multiple columns to a file?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Crosstab Conversion Command

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Can the Advanced Query Command suppress records with duplicate unique IDs?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Can I use the UPDATE or INSERT statements with Advanced Query?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Convert XLSX to CSV Command

This article describes how to use the Convert XLSX to CSV Command.
OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Pivot vs. Unpivot Command

This article describes when to use the Tabular Transformation Pivot versus the Unpivot Command
OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago