Preface
Informatica Managed File Transfer Welcome Overview
- Managed File Transfer General Features
  - Workflow Automation
  - Ad-Hoc File Transfers and Collaboration
- Getting Started
  - Screen Tips
  - Login
Dashboard
Resources
Workflows
Task Reference
Services Overview
Users
Logs and Reports
Encryption
System
Appendix
Glossary Terms
- AES
- Asymmetric
- Asymmetric Cryptology
- Authentication
- Certificate
- Certificate Authority
- CIDR
- Cipher
- Cryptology
- CSV
- Decryption
- Diffie-Hellman/DSS
- Digital Signature
- DSA
- Element
- Encryption
- Fingerprint
- FTP
- FTPS
- Hash Function
- HTTP
- HTTPS
- ICAP
- Icon
- ISO format
- JCE Service Provider
- JDBC drivers
- JKS
- Key
- Key Alias/Key ID
- Key Pair
- Key Store
- MDN
- MMS
- Non-Repudiation
- Passphrase
- PKCS12
- Private Key
- Project
- Public Key
- Public Key Cryptology
- Public Keyring
- RSA
- Run Priority
- SAML
- Secret Key
- Secret Keyring
- Self-Signed Certificate
- SFTP
- Signing
- SMS
- SMTP
- SSH
- SSL
- SSO
- Symmetric
- Symmetric Cryptology
- URL
- Variable
- Verification
- XML

User Guide

10.2.2
- 10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.1
- 10.2

Back Next

Example 1: Modify a RowSet Using Existing Columns

In this example, a Read CSV task creates a RowSet variable named myData that contains 6 columns of data. The following graphic illustrates the data contained in the RowSet:

Example Data:

${myData} RowSet Variable
${myData[1]}	${myData[2]}	${myData[3]}	${myData[4]}	${myData[5]}	${myData[6]}
34594	Heather	Banks	1998-01-19	BB001	72000
34593	Tina	Young	2010-04-01	BB001	65000
34590	Kathy	Harris	2007-09-30	KH001	105000
34592	Mark	Walker	2012-11-15	KH001	87500
34591	John	Davis	2001-06-15	KH001	85000

The Modify RowSet task will be used to add a new column at Index 4, modify the value of the data in column 3, and remove column 5. Follow the steps below to use data from a RowSet, modify existing columns, and output the results to a new RowSet:

Before adding a Modify RowSet task, you must have an Output RowSet variable from another task. The Output RowSet variable is used as the Input RowSet variable on the Modify RowSet task.

From within the Project Designer page, expand the Data Translation folder in the Component Library, and then drag the Modify RowSet task to the Project Outline.

On the Basic tab of the Modify RowSet task, specify the following values:

Input RowSet Variable: Specify the name of a variable of type RowSet which contains the data to modify. For example, ${myData}.
Output RowSet Variable: Specify the name of the variable that will contain the modified data. This will be a variable type of RowSet. If this variable exists it will be overwritten, otherwise it will be created.
Start With Existing Columns: Choose if you want to start with all columns from the input RowSet (true) or would rather specify which columns you want specifically (false). Choose true.

In the Modify RowSet task window, from the

Add

button in the sub-menu, click

Add New Column

Specify the Index where the new column will be added, and the column value that will be written to the Output RowSet variable. In the example, a new column will be created at Index 4. The column will contain the value "Chicago."

In the Modify RowSet task window, from the

Add

button in the sub-menu, click

Add Modify Column

Specify the Index for the column to modify, and enter a new column value. In the example, the string data in column 3 will be converted to uppercase text (i.e. from 'James' to 'JAMES').

In the Modify RowSet task window, from the

Add

button in the sub-menu, click

Add Remove Column

Specify the Index for the column you want to remove.

Click the

Save

button when finished.

The modifiedData RowSet Variable will contain 6 columns.

${modifiedData} RowSet Variable
${modifiedData[1]}	${modifiedData[2]}	${modifiedData[3]}	${modifiedData[4]}	${modifiedData[5]}	${modifiedData[6]}
34594	Heather	BANKS	Chicago	1998-01-19	72000
34593	Tine	YOUNG	Chicago	2010-04-01	65000
34590	Kathy	HARRIS	Chicago	2007-09-30	105000
34592	Mark	WALKER	Chicago	2012-11-15	87500
34591	John	DAVIS	Chicago	2001-06-15	85000

Rename Saved Search

Table of Contents

User Guide

User Guide

Example 1: Modify a RowSet Using Existing Columns

Example 1: Modify a RowSet Using Existing Columns