Help Desk

Submit a ticket My Tickets
Welcome
Login

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 support@onecloud.io.

Login to post a comment