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:
- 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.
- Use OneCloud's File Utilities BizApp -> Find and Replace and replace the header placeholder with the required column headers.
- Add a second Find and Replace Command and replace the value placeholder with a string of commas (one comma per column added).
- See Sample Output
If you still require assistance, please contact support@onecloud.io.