exceldecode
- 1 Minute to read
- Print
- DarkLight
- PDF
exceldecode
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Creates a mapping between a source value and a new output value by reading codes from excel
| Key | Value(s) | Description |
|---|---|---|
| method | "buildBakedField" | Creates a mapping between a source value and a new output value by reading codes from excel |
| targetTable | "TableName" | |
| p1 | "SourceFieldName" | |
| overwrite | true/false | |
| name | "DecodeName" | |
| function | "exceldecode" | |
| forceString | true/false | |
| workbook | "WorkbookPathandFile" | |
| worksheet | "WorksheetName" | |
| codeColumn | "ColumnLetter" | The column to look in for the existing field value (input value). e.g., A |
| decodeColumn | "ColumnLetter" | The column to look in for the decode value (output value) e.g., B |
| wild | true/false | |
| regex | true/false | |
| row | RowNumber |
{Explanation}
{
"method": "BuildBakedField",
"project": "SalesData1",
"targetTable": "Sales",
"p1": "Product",
"overwrite": true,
"name": "Segment Code",
"function": "exceldecode",
"forceString": false,
"workbook": "%DATAPATH%05_LookupFiles/ClothingDecodes01.xlsx",
"worksheet": "Article Scoring Table",
"codeColumn": "A",
"decodeColumn": "B",
"wild": false,
"regex": false,
"row": 2
}
Was this article helpful?