{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"62ce9d94a1ec64b844cbf378","instance_id":"68d4bfd4-ff05-410f-9f01-a3a6e23e6c8b","instance_version":5,"link_map":{"link100":{"src_view_id":"output0","dst_view_id":"input0","src_id":"5d325aaa-29a0-458e-b475-a692e5456fd6","dst_id":"73d1e654-b3ef-4f86-8886-f224d4b7b822","isGoto":false},"link101":{"src_view_id":"output0","dst_view_id":"input0","src_id":"d6b4c779-a075-4653-a93d-a9337411eb89","dst_id":"5d325aaa-29a0-458e-b475-a692e5456fd6","isGoto":false}},"link_serial":102,"property_map":{"info":{"notes":{"value":null},"label":{"value":"C12000185_Transform_Pivot_Test to verify the behaviour when static fields are missing"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"apranay+role@snaplogic.com"}},"input":{},"settings":{"imports":{"value":[]},"suspendable":{"value":false},"error_param_table":{"value":[]},"param_table":{"value":[]},"error_pipeline":{"expression":false,"value":null}},"error":{"error_behavior":{"value":"none"}},"output":{}},"render_map":{"pan_x_num":0,"default_snaplex":"62336f97b1e7242b088c4441","scale_ratio":1,"detail_map":{"73d1e654-b3ef-4f86-8886-f224d4b7b822":{"grid_x_int":4,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"output":{},"rot_int":0},"d6b4c779-a075-4653-a93d-a9337411eb89":{"grid_x_int":2,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"output":{},"input":{},"rot_int":0},"5d325aaa-29a0-458e-b475-a692e5456fd6":{"grid_x_int":3,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"rot_int":0}},"pan_y_num":0},"snap_map":{"73d1e654-b3ef-4f86-8886-f224d4b7b822":{"class_fqid":"com-snaplogic-snaps-test-assertequals_1-ALL5655","class_id":"com-snaplogic-snaps-test-assertequals","class_version":1,"instance_fqid":"73d1e654-b3ef-4f86-8886-f224d4b7b822_2","instance_id":"73d1e654-b3ef-4f86-8886-f224d4b7b822","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Assert Equals"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"evaluateWithInputDocument":{"value":true},"editable_content":{"value":"[{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"Name\",\"Value\":\"David\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"Last Date Available\",\"Value\":\"2016\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"2010\",\"Value\":\"90\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"2012\",\"Value\":\"100\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"2014\",\"Value\":\"120\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"2016\",\"Value\":\"140\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"Name\",\"Value\":\"Joseph\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"Last Date Available\",\"Value\":\"2014\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"2010\",\"Value\":\"90\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"2012\",\"Value\":\"160\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"2014\",\"Value\":\"220\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"2016\",\"Value\":\"200\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"Name\",\"Value\":\"Roy\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"Last Date Available\",\"Value\":\"2014\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"2010\",\"Value\":\"85\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"2012\",\"Value\":\"120\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"2014\",\"Value\":\"210\"},{\"Missing02\":null,\"Missing03\":\"\",\"Missing04\":0,\"colDetails\":\"2016\",\"Value\":\"150\"}]"},"execution_mode":{"value":"Validate & Execute"}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{}},"class_build_tag":"ALL5655"},"5d325aaa-29a0-458e-b475-a692e5456fd6":{"class_fqid":"com-snaplogic-snaps-transform-pivot_1-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-pivot","class_version":1,"instance_fqid":"5d325aaa-29a0-458e-b475-a692e5456fd6_2","instance_id":"5d325aaa-29a0-458e-b475-a692e5456fd6","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Pivot - Static"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"targetValueNoPivotsBehavior":{"value":"Substitute null"},"execution_mode":{"value":"Validate & Execute"},"targetFieldFullPath":{"value":true},"fields":{"value":[{"field":{"value":"$Missing01"},"ifFieldAbsent":{"value":"Ignore"}},{"field":{"value":"$Missing02"},"ifFieldAbsent":{"value":"Substitute null"}},{"field":{"value":"$Missing03"},"ifFieldAbsent":{"value":"Substitute empty string"}},{"field":{"value":"$Missing04"},"ifFieldAbsent":{"value":"Substitute zero"}}]},"targetField":{"value":"$colDetails"},"fieldsAsStatic":{"value":true},"targetValue":{"value":"$Value"},"targetFieldNoPivotsBehavior":{"value":"Substitute null"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"SNAPSHOT"},"d6b4c779-a075-4653-a93d-a9337411eb89":{"class_fqid":"com-snaplogic-snaps-transform-csvgenerator_1-snapsrc625","class_id":"com-snaplogic-snaps-transform-csvgenerator","class_version":1,"instance_fqid":"d6b4c779-a075-4653-a93d-a9337411eb89_1","instance_id":"d6b4c779-a075-4653-a93d-a9337411eb89","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"CSV Generator"}},"view_serial":100,"input":{},"settings":{"editable_content":{"value":"Name,Last Date Available,2010,2012,2014,2016\nDavid,2016,90,100,120,140\nJoseph,2014,90,160,220,200\nRoy,2014,85,120,210,150"},"execution_mode":{"value":"Validate & Execute"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"snapsrc625"}},"path_id":"/QA/TousifDemo/SNAP-9429 - Pivot","path_snode":"62be8c002445576967ba43ea","target_runtime":"standard"}