Help Desk

Submit a ticket My Tickets

How do I add multiple columns to a file?

Issue Summary:

There are currently 10 columns in a file and I want to add 5 more. How can I do this in OneCloud? 

Issue Solution:

  1. Use OneCloud's Tabular Transformation BizApp -> Insert Column and add a column with the header "EMPTY_REPLACED_HEADER" and assign the value "EMPTY_REPLACED_VALUE"  to each row. Set the insert index based upon the number of columns in the source.

  2. Use OneCloud's File Utilities BizApp -> Find and Replace and replace the header placeholder with the required column headers.

  3. Add a second Find and Replace Command and replace the value placeholder with a string of commas (one comma per column added).

  4. See Sample Output

If you still require assistance, please contact

Login to post a comment