{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"5abe11faa478d7435e3d1394","instance_id":"5f703d67-8361-4095-a19c-e3a58ca24a0e","instance_version":6,"link_map":{"link100":{"src_view_id":"output0","dst_view_id":"input0","src_id":"af33447a-7789-4776-b918-656275a37f8f","dst_id":"e03d42d4-d51c-4401-9850-8994659d33eb","isGoto":false},"link101":{"src_view_id":"output0","dst_view_id":"input0","src_id":"2803e7bc-d4ef-4183-9873-08af4f43155a","dst_id":"af33447a-7789-4776-b918-656275a37f8f","isGoto":false}},"link_serial":102,"property_map":{"info":{"notes":{"value":null},"label":{"value":"sn3402-M-11-SAC_append_fact_table_for_model_id"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"admin@snaplogic.com"}},"input":{},"settings":{"imports":{"value":[]},"error_param_table":{"value":[]},"param_table":{"value":[]},"error_pipeline":{"expression":false,"value":null}},"error":{"error_behavior":{"value":"none"},"e03d42d4-d51c-4401-9850-8994659d33eb_error0":{"view_type":{"value":"document"},"label":{"value":"SAC Create - error0"}}},"output":{"e03d42d4-d51c-4401-9850-8994659d33eb_output0":{"view_type":{"value":"document"},"label":{"value":"SAC Create - output0"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"59f778ffa478d70c87a6a039","scale_ratio":1,"detail_map":{"af33447a-7789-4776-b918-656275a37f8f":{"grid_x_int":3,"grid_y_int":2,"rot_tail_int":0,"output":{},"input":{},"rot_int":0},"2803e7bc-d4ef-4183-9873-08af4f43155a":{"grid_x_int":2,"rot_int":0,"grid_y_int":2,"rot_tail_int":0,"output":{}},"e03d42d4-d51c-4401-9850-8994659d33eb":{"grid_x_int":4,"rot_int":0,"grid_y_int":2,"rot_tail_int":0,"error":{"error0":{"dx_int":0,"rot_int":0,"dy_int":-1}}}},"pan_y_num":0},"snap_map":{"af33447a-7789-4776-b918-656275a37f8f":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"af33447a-7789-4776-b918-656275a37f8f_1","instance_id":"af33447a-7789-4776-b918-656275a37f8f","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":true,"value":"$Account_BestRunJ_sold"},"targetPath":{"value":"$Account_BestRunJ_sold"}},{"expression":{"expression":true,"value":"$Date_703i1904sd"},"targetPath":{"value":"$Date_703i1904sd"}},{"expression":{"expression":true,"value":"$Location_4nm2e04531"},"targetPath":{"value":"$Location_4nm2e04531"}},{"expression":{"expression":true,"value":"$Measure_Column"},"targetPath":{"value":"$Measure_Column"}},{"expression":{"expression":true,"value":"$Product_3e315003an"},"targetPath":{"value":"$Product_3e315003an"}},{"expression":{"expression":true,"value":"$Sales_Manager__5w3m5d06b5"},"targetPath":{"value":"$Sales_Manager__5w3m5d06b5"}},{"expression":{"expression":true,"value":"$Store_3z2g5g06m4"},"targetPath":{"value":"$Store_3z2g5g06m4"}},{"expression":{"expression":true,"value":"$Version_BestRunJsold_V"},"targetPath":{"value":"$Version_BestRunJsold_V"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"SNAPSHOT"},"2803e7bc-d4ef-4183-9873-08af4f43155a":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"2803e7bc-d4ef-4183-9873-08af4f43155a_1","instance_id":"2803e7bc-d4ef-4183-9873-08af4f43155a","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"JSON Generator"}},"view_serial":100,"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}},"settings":{"editable_content":{"value":"## Enter your JSON-encoded data in this space. Note that this text is\n## treated as an Apache Velocity template, so you can substitute values\n## from input documents or the pipeline parameters. See the following\n## URL for more information about Velocity:\n## https://velocity.apache.org/engine/devel/user-guide.html\n\n[\n {\n \"Account_BestRunJ_sold\": \"Discount\",\n \"Store_3z2g5g06m4\": \"ST86\",\n \"Location_4nm2e04531\": \"CT1\",\n \"Product_3e315003an\": \"PD26\",\n \"Sales_Manager__5w3m5d06b5\": \"SM7\",\n \"Date_703i1904sd\": \"201401\",\n \"Version_BestRunJsold_V\": \"Actual\",\n \"Measure_Column\": \"1\"\n },\n {\n \"Account_BestRunJ_sold\": \"Discount\",\n \"Store_3z2g5g06m4\": \"ST101\",\n \"Location_4nm2e04531\": \"CT1\",\n \"Product_3e315003an\": \"PD11\",\n \"Sales_Manager__5w3m5d06b5\": \"SM7\",\n \"Date_703i1904sd\": \"201403\",\n \"Version_BestRunJsold_V\": \"Actual\",\n \"Measure_Column\": \"3\"\n },\n {\n \"Account_BestRunJ_sold\": \"Discount\",\n \"Store_3z2g5g06m4\": \"ST101\",\n \"Location_4nm2e04531\": \"CT1\",\n \"Product_3e315003an\": \"PD11\",\n \"Sales_Manager__5w3m5d06b5\": \"SM7\",\n \"Date_703i1904sd\": \"201403\",\n \"Version_BestRunJsold_V\": \"Actual\",\n \"Measure_Column\": \"3\"\n },\n {\n \"Account_BestRunJ_sold\": \"Discount\",\n \"Store_3z2g5g06m4\": \"ST88\",\n \"Location_4nm2e04531\": \"CT1\",\n \"Product_3e315003an\": \"PD23\",\n \"Sales_Manager__5w3m5d06b5\": \"SM7\",\n \"Date_703i1904sd\": \"201402\",\n \"Version_BestRunJsold_V\": \"Actual\",\n \"Measure_Column\": \"2\"\n },\n {\n \"Account_BestRunJ_sold\": \"Discount\",\n \"Store_3z2g5g06m4\": \"ST90\",\n \"Location_4nm2e04531\": \"CT1\",\n \"Product_3e315003an\": \"PD11\",\n \"Sales_Manager__5w3m5d06b5\": \"SM7\",\n \"Date_703i1904sd\": \"201402\",\n \"Version_BestRunJsold_V\": \"Actual\",\n \"Measure_Column\": \"2\"\n }\n]\n\n\n## Tips:\n## * The sample data above will generate a single empty document, uncomment\n## the line in the middle to include the sample fields. Adding more\n## objects to the root array will cause the snap to generate more\n## than one document.\n## * Pipeline parameters can be referenced by prefixing the parameter\n## name with an underscore, like so:\n## ${_pipelineParamName}\n## * If you add an input view to the snap, this template will be\n## evaluated for each input document.\n## * Fields in the input documents can be referenced by prefixing them\n## with a dollar-sign ($), like so:\n## $parent.child[0].value\n## * Any referenced document values and pipeline parameters will\n## automatically be JSON-encoded when they are inserted into the final\n## JSON document. You should not have to worry about escaping values\n## yourself.\n## * If you are having troubles getting a template to produce valid JSON,\n## you can add an error view to the snap to get a document that\n## contains the output of the template evaluation."},"arrayElementsAsDocuments":{"value":true}}},"class_build_tag":"SNAPSHOT"},"e03d42d4-d51c-4401-9850-8994659d33eb":{"class_fqid":"com-snaplogic-snaps-sac-saccreate_1-1259","class_id":"com-snaplogic-snaps-sac-saccreate","class_version":1,"instance_fqid":"e03d42d4-d51c-4401-9850-8994659d33eb_4","instance_id":"e03d42d4-d51c-4401-9850-8994659d33eb","instance_version":4,"property_map":{"info":{"notes":{"value":null},"label":{"value":"SAC Create"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"serviceType":{"value":"Fact table"},"batchSize":{"expression":false,"value":2},"executable_during_suggest":{"value":true},"dimensionId":{"expression":false,"value":null},"Operation":{"value":"APPEND"},"modelId":{"expression":false,"value":"sap.epm:BestRunJuice_SampleModel"}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"continue"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"1259"}},"path_id":"/snaplogic/projects/Krishna PVG","path_snode":"59fa08b3a478d737d8b8ce3c"}