{
  "json": {
    "category": "mapping",
    "type": "mapping",
    "encoding": "UTF-8",
    "version": "1.0"
  },
 "cloneElements": "",
    "filters": "",
    "variables": {
        "variable": []
    },
    "globalParameters": {
        "keys": {
            "key": []
        },
        "contextVariables": {
            "contextVariable": []
        }
    },
    "connections": {
        "connectionVariable": []
    },
    "functions": {
        "externalFunction": []
    },
  "filterUnmappedElements": false,
    "indentOutputXML": true,
    "xslVersion": "1.1",
    "enableStreaming": false,
    "filterEmptyElements": false,
    "xslTransformer": "Saxon",
    "characterSetEncoding": "UTF-8",
    "DataViewerRecordCount": 50,
    "dbQueryCaching": false,
    "isQuickSplittingEnabled": false,
    "TreeExpandLevelCountForWebService": 5,
    "TreeExpandLevelForEasySchemaExtensions": 10,
    "SelfRecursionLevel": 0,
    "EnableTypesBuffering": true,
    "TreeExpandLevelCount": 3,
    "onDemandLoadingOfXMLSchemaTree": true,
    "settingConfigs": {
        "xslVersion": "1.1",
        "xslTransformer": "Saxon",
        "filterUnmappedElements": false,
        "indentOutputXML": true,
        "filterEmptyElements": false,
        "enableStreaming": false,
        "characterSetEncoding": "UTF-8",
        "DataViewerRecordCount": 50,
        "dbQueryCaching": false,
        "isQuickSplittingEnabled": false,
        "TreeExpandLevelCountForWebService": 5,
        "TreeExpandLevelForEasySchemaExtensions": 10,
        "SelfRecursionLevel": 0,
        "EnableTypesBuffering": true,
        "TreeExpandLevelCount": 3,
        "onDemandLoadingOfXMLSchemaTree": true,
        "cDataSectionElements": "",
        "excludeResultPrefixes": "saxonJavaMappingTransformation saxonJavaMapperQueryExecutor saxonJavaAggregateFunctionHandler str",
        "cacheIncludedSchemas": false,
        "processElementFormDefault": true,
        "isAutoSaveEnable": false
    },
    "disableOuputNodes": {
        "disableOutputNodeProperty": []
    },
    "isCustomXSLT": false,
    "contextSchemaLoadedAtSource": false,
    "contextSchemaLoadedAtTarget": false,
    "webservice": {
        "consumers": {
            "consumer": []
        }
    },
    "GlobalPreCustomXSL": "",
    "GlobalPostCustomXSL": "",
    "xslTemplates": {
        "xslTemplateData": []
    },
    "mappingTempId": null,
    "sourceXpath": "",
    "targetXpath": "",
    "connectorInfo": {},
    "cDataSectionElements": "",
    "splittingData": false,
    "splitNumberOfRecords": "500",
    "parallelProcessing": false,
    "maximumConcurrentProcessor": "1",
    "CustomAutoMapInUse": "",
    "excludeResultPrefixes": "saxonJavaMappingTransformation saxonJavaMapperQueryExecutor saxonJavaAggregateFunctionHandler str",
    "cacheIncludedSchemas": false,
    "metaData": "",
    "processElementFormDefault": true,
  "mappingInformation": {
    "mappingVersion": "6.1",
    "mappingName": "Text_To_Excel_ID_Name",
    "mappingProject": "Project:Default",
    "mappingDescription": "Text to Excel mapping for ID and Name",
    "sourceSchemaID": "TextSchema:1455874307750047744",
    "targetSchemaID": "ExcelSchema:1455874727188836352",
    "mappingOwnerGroup": "",
        "mappingOwner": "",
        "mappingLastModifiedBy": "",
        "mappingCreationDate": "",
        "mappingModifiedDate": "",
        "reusable": null
  },
  "namespace": "",
  "namespaceList": [],
  "foreach": "",
  "targetRoots": {
    "targetRoot": [
      {
        "name": "Root",
        "schemaName": "Excel_Target",
        "schemaID": "ExcelSchema:1455874727188836352",
        "stream": "output_1"
      }
    ]
  },
  "sourceRoots": {
    "sourceRoot": [
      {
        "name": "Root",
        "schemaName": "Text_Source",
        "schemaID": "TextSchema:1455874307750047744"
      }
    ]
  },
  "contextSchemaDefinition": "",
  "maps": [
    {
      "order": 1,
      "targetName": "Excel_Target",
      "targetfield": "Did",
      "targetfieldpath": "/Root/Sheet1/Did",
      "defaultEditor": "graphical",
      "graphicalMappingJson":[],
      "expression": "$Input_Text_Source/Root/ID",
      "targetrecord": "Sheet1",
      "mapping": [],
      "markComplete": false,
      "mapId": "Map-1"
    },
    {
      "order": 2,
      "targetName": "Excel_Target",
      "targetfield": "Dname",
      "targetfieldpath": "/Root/Sheet1/Dname",
      "defaultEditor": "graphical",
      "expression": "$Input_Text_Source/Root/Name",
      "targetrecord": "Sheet1",
      "mapping": [],
      "markComplete": false,
      "mapId": "Map-2"
    }
  ],
  "sourceExpandLevel": 3,
  "targetExpandLevel": 3,
  "sourceTargetSchemaDetails": {
        "sourceSchema": {
            "name": "",
            "root": false,
            "leaf": false,
            "schemaName": "Input_undefined",
            "schemaType": "",
            "xpath": "/",
            "namespacePrefix": "",
            "currentForEach": "",
            "currentMapping": "",
            "currentComment": "",
            "preCustomXSL": "",
            "postCustomXSL": "",
            "disableOutputEscaping": false,
            "order": 1,
            "filter": false,
            "loadedOptimized": false,
            "namespaceRemoved": "",
            "attribute": false,
            "localVariableList": [],
            "sortList": [],
            "children": [
                {
                    "name": "Root",
                    "root": true,
                    "leaf": false,
                    "schemaName": "Input_Text_Source",
                    "schemaNameWithoutInput": "Text_Source",
                    "schemaType": "TextSchema",
                    "xpath": "/Root",
                    "namespacePrefix": "",
                    "currentForEach": "",
                    "currentMapping": "",
                    "currentComment": "",
                    "preCustomXSL": "",
                    "postCustomXSL": "",
                    "disableOutputEscaping": false,
                    "order": 1,
                    "filter": false,
                    "loadedOptimized": false,
                    "namespaceRemoved": "",
                    "attribute": false,
                    "localVariableList": [],
                    "sortList": [],
                    "children": [
                        {
                            "name": "Record",
                            "root": false,
                            "leaf": false,
                            "schemaName": "Input_Text_Source",
                            "schemaNameWithoutInput": "Text_Source",
                            "schemaType": "",
                            "xpath": "/Root/Record",
                            "namespacePrefix": "",
                            "currentForEach": "",
                            "currentMapping": "",
                            "currentComment": "",
                            "preCustomXSL": "",
                            "postCustomXSL": "",
                            "disableOutputEscaping": false,
                            "order": 1,
                            "filter": false,
                            "loadedOptimized": false,
                            "namespaceRemoved": "",
                            "attribute": false,
                            "localVariableList": [],
                            "sortList": [],
                            "children": [
                                {
                                    "name": "ID",
                                    "root": false,
                                    "leaf": true,
                                    "schemaName": "Input_Text_Source",
                                    "schemaNameWithoutInput": "Text_Source",
                                    "schemaType": "",
                                    "xpath": "/Root/Record/ID",
                                    "namespacePrefix": "",
                                    "currentForEach": "",
                                    "currentMapping": "",
                                    "currentComment": "",
                                    "preCustomXSL": "",
                                    "postCustomXSL": "",
                                    "disableOutputEscaping": false,
                                    "order": 1,
                                    "filter": false,
                                    "loadedOptimized": false,
                                    "namespaceRemoved": "",
                                    "attribute": false,
                                    "localVariableList": [],
                                    "sortList": [],
                                    "children": [],
                                    "totalChildMappings": 0
                                },
                                {
                                    "name": "Name",
                                    "root": false,
                                    "leaf": true,
                                    "schemaName": "Input_Text_Source",
                                    "schemaNameWithoutInput": "Text_Source",
                                    "schemaType": "",
                                    "xpath": "/Root/Record/Name",
                                    "namespacePrefix": "",
                                    "currentForEach": "",
                                    "currentMapping": "",
                                    "currentComment": "",
                                    "preCustomXSL": "",
                                    "postCustomXSL": "",
                                    "disableOutputEscaping": false,
                                    "order": 1,
                                    "filter": false,
                                    "loadedOptimized": false,
                                    "namespaceRemoved": "",
                                    "attribute": false,
                                    "localVariableList": [],
                                    "sortList": [],
                                    "children": [],
                                    "totalChildMappings": 0
                                },
                                {
                                    "name": "@recordNumber",
                                    "root": false,
                                    "leaf": true,
                                    "schemaName": "Input_Text_Source",
                                    "schemaNameWithoutInput": "Text_Source",
                                    "schemaType": "",
                                    "xpath": "/Root/Record/@recordNumber",
                                    "namespacePrefix": "",
                                    "currentForEach": "",
                                    "currentMapping": "",
                                    "currentComment": "",
                                    "preCustomXSL": "",
                                    "postCustomXSL": "",
                                    "disableOutputEscaping": false,
                                    "order": 1,
                                    "filter": false,
                                    "loadedOptimized": false,
                                    "namespaceRemoved": "",
                                    "attribute": "true",
                                    "localVariableList": [],
                                    "sortList": [],
                                    "children": [],
                                    "totalChildMappings": 0
                                }
                            ],
                            "totalChildMappings": 0
                        }
                    ],
                    "totalChildMappings": 0
                }
            ],
            "totalChildMappings": 0
        },
        "destinationSchema": {
            "name": "",
            "root": false,
            "leaf": false,
            "schemaName": "Input_Excel_Target",
            "schemaType": "",
            "xpath": "/",
            "namespacePrefix": "",
            "currentForEach": "",
            "currentMapping": "",
            "currentComment": "",
            "preCustomXSL": "",
            "postCustomXSL": "",
            "disableOutputEscaping": false,
            "order": 1,
            "filter": false,
            "loadedOptimized": false,
            "namespaceRemoved": "",
            "attribute": false,
            "localVariableList": [],
            "sortList": [],
            "children": [
                {
                    "name": "Root",
                    "root": true,
                    "leaf": false,
                    "schemaName": "Input_Excel_Target",
                    "schemaNameWithoutInput": "Excel_Target",
                    "schemaType": "ExcelSchema",
                    "xpath": "/Root",
                    "streamName": "output_1",
                    "namespacePrefix": "",
                    "currentForEach": "",
                    "currentMapping": "",
                    "currentComment": "",
                    "preCustomXSL": "",
                    "postCustomXSL": "",
                    "disableOutputEscaping": false,
                    "order": 1,
                    "filter": false,
                    "loadedOptimized": false,
                    "namespaceRemoved": "",
                    "attribute": false,
                    "localVariableList": [],
                    "sortList": [],
                    "children": [
                        {
                            "name": "Record",
                            "root": false,
                            "leaf": false,
                            "schemaName": "Input_Excel_Target",
                            "schemaNameWithoutInput": "Excel_Target",
                            "schemaType": "",
                            "xpath": "/Root/Record",
                            "streamName": "output_1",
                            "namespacePrefix": "",
                            "currentForEach": "",
                            "currentMapping": "",
                            "currentComment": "",
                            "preCustomXSL": "",
                            "postCustomXSL": "",
                            "disableOutputEscaping": false,
                            "order": 1,
                            "filter": false,
                            "loadedOptimized": false,
                            "namespaceRemoved": "",
                            "attribute": false,
                            "localVariableList": [],
                            "sortList": [],
                            "children": [
                                {
                                    "name": "Did",
                                    "root": false,
                                    "leaf": true,
                                    "schemaName": "Input_Excel_Target",
                                    "schemaNameWithoutInput": "Excel_Target",
                                    "schemaType": "",
                                    "xpath": "/Root/Record/Did",
                                    "streamName": "output_1",
                                    "namespacePrefix": "",
                                    "currentForEach": "",
                                    "currentComment": "",
                                    "preCustomXSL": "",
                                    "postCustomXSL": "",
                                    "disableOutputEscaping": false,
                                    "order": 1,
                                    "filter": false,
                                    "loadedOptimized": false,
                                    "namespaceRemoved": "",
                                    "attribute": false,
                                    "localVariableList": [],
                                    "sortList": [],
                                    "children": [],
                                    "totalChildMappings": 1
                                },
                                {
                                    "name": "Dname",
                                    "root": false,
                                    "leaf": true,
                                    "schemaName": "Input_Excel_Target",
                                    "schemaNameWithoutInput": "Excel_Target",
                                    "schemaType": "",
                                    "xpath": "/Root/Record/Dname",
                                    "streamName": "output_1",
                                    "namespacePrefix": "",
                                    "currentForEach": "",
                                    "currentComment": "",
                                    "preCustomXSL": "",
                                    "postCustomXSL": "",
                                    "disableOutputEscaping": false,
                                    "order": 1,
                                    "filter": false,
                                    "loadedOptimized": false,
                                    "namespaceRemoved": "",
                                    "attribute": false,
                                    "localVariableList": [],
                                    "sortList": [],
                                    "children": [],
                                    "totalChildMappings": 1
                                },
                                {
                                    "name": "@recordNumber",
                                    "root": false,
                                    "leaf": true,
                                    "schemaName": "Input_Excel_Target",
                                    "schemaNameWithoutInput": "Excel_Target",
                                    "schemaType": "",
                                    "xpath": "/Root/Record/@recordNumber",
                                    "streamName": "output_1",
                                    "namespacePrefix": "",
                                    "currentForEach": "",
                                    "currentMapping": "",
                                    "currentComment": "",
                                    "preCustomXSL": "",
                                    "postCustomXSL": "",
                                    "disableOutputEscaping": false,
                                    "order": 1,
                                    "filter": false,
                                    "loadedOptimized": false,
                                    "namespaceRemoved": "",
                                    "attribute": "true",
                                    "localVariableList": [],
                                    "sortList": [],
                                    "children": [],
                                    "totalChildMappings": 0
                                }
                            ],
                            "totalChildMappings": 3
                        }
                    ],
                    "totalChildMappings": 3
                }
            ],
            "totalChildMappings": 3
        }
    }
}