Write headers - Automate_Studio - 20.3

Automate Studio with Connect User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
20.3
Language
English
Product name
Automate Studio
Title
Automate Studio with Connect User Guide
Topic type
Administration
Overview
Installation
How Do I
First publish date
2018

If the Excel data file for a script is not available, you might need to write headers to a new sheet. You can write headers from Studio and also from the Excel Add-in.

  1. Click the Map tab or the Run tab.
  2. Click Write Headers.

    If Write Headers is grayed out, click Unlock Headers.

Write headers in cell-based mapping in Transaction

In cell-based mapping, headers are written to the cell immediately to the left of the mapped cell. If the prospective header cell contains data, the data is not overwritten.

  • If a field is mapped to C4, the header is written to B4.
  • If a header appears in column A, you can choose to continue to map the data but not to write the header, or cancel the entire mapping.
  • If an ID-based loop is mapped to column C and data appears in C1, you can choose to continue to map the data but not to write the header, or you can cancel the entire mapping.
  • If a range-based loop starts in column C4, the header appears in column C3. To write the header, you must specify the range. If the prospective header cell contains data, you can continue to map the data without the header or you can cancel the entire mapping.
  • For Auto Map, the header is written only if the header cell is empty.
  • For a multiple-cell selection that is dragged to the mapper to map uploads, the header is written only if the header cell is empty.