Product Documentation
Abstract
Transformation Extender version 9.0.0.2 includes the new Excel adapter. The Excel adapter reads data from and maps data to a sheet in a Microsoft® Excel workbook.
Content
In Design Studio, use the Excel importer (File > Import) to create a type tree based on a specified worksheet in the Excel workbook.
Excel adapter commands:
Use EXCEL as the adapter command alias on input and output cards and in GET and PUT rules. For example:
| Input source override execution command | -IAEXCEL card_num |
| Output target override execution command | -OAEXCEL card_num |
-F workbook.xls[x]
-FILE workbook.xls[x]
The Excel workbook name. Use this command for data sources or data targets.
The -FILE command is optional on input cards and GET rules. (For example, the workbook name is not required if a map uses the File adapter to read an Excel workbook and passes the data in memory to the Excel adapter.) The adapter can read from either the .xls or the .xlsx workbook format.
The -FILE command is required on output cards and PUT rules. The command always writes Excel data in the .xlsx workbook format.
-W sheetname
-WRKSHEET sheetname
The Excel sheet name. This command is required. Use this command for data sources or data targets.
-P template_filepath
-TEMPLATE template_filepath
The file path to the Excel template. This command is optional. Use this command for data targets.
Inbound adapter example:
- Command line: -F test.xlsx -W Sheet1
GET rule: =PARSE(GET("EXCEL", "-W Sheet1 -T", Input))
Inbound mapping rules are likely to be based on row number and the EXTRACT function:
Outbound mapping rules can be index-based. RowNumber indicates where to insert the data.
[{"Product":{"code":"SSVSD8","label":"IBM Transformation Extender"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"9.0.0.2","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
08 August 2018
UID
swg27049838