{"class_fqid":"com-snaplogic-pipeline_9","snode_id":"62ce8ac261cff10ee54e5bc8","instance_id":"84db8285-baa5-430e-8960-1328fc7d1637","instance_version":23,"link_map":{"link111":{"src_view_id":"output0","dst_view_id":"input0","src_id":"84d5fd3d-ba4e-46bc-a64e-3e18fa238846","dst_id":"392c6bd0-b22c-4d8e-8de7-f60439758ac6","isGoto":false},"link109":{"src_view_id":"output0","dst_view_id":"input0","src_id":"58e560b6-1a53-49d2-b5c6-9e5a8653b1f6","dst_id":"84d5fd3d-ba4e-46bc-a64e-3e18fa238846","isGoto":false}},"link_serial":112,"property_map":{"info":{"notes":{"value":null},"label":{"value":"C12000183_Transform_Pivot_Test to verify behaviour of selected fields as static_checked"},"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":{"58e560b6-1a53-49d2-b5c6-9e5a8653b1f6":{"grid_x_int":2,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"input":{},"rot_int":0},"84d5fd3d-ba4e-46bc-a64e-3e18fa238846":{"grid_x_int":3,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"rot_int":0},"392c6bd0-b22c-4d8e-8de7-f60439758ac6":{"grid_x_int":4,"index":null,"recommendation_id":null,"source":"","grid_y_int":1,"rot_tail_int":0,"output":{},"rot_int":0}},"pan_y_num":0},"snap_map":{"58e560b6-1a53-49d2-b5c6-9e5a8653b1f6":{"class_fqid":"com-snaplogic-snaps-transform-csvgenerator_1-snapsrc625","class_id":"com-snaplogic-snaps-transform-csvgenerator","class_version":1,"instance_fqid":"58e560b6-1a53-49d2-b5c6-9e5a8653b1f6_7","instance_id":"58e560b6-1a53-49d2-b5c6-9e5a8653b1f6","instance_version":7,"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"},"84d5fd3d-ba4e-46bc-a64e-3e18fa238846":{"class_fqid":"com-snaplogic-snaps-transform-pivot_1-SNAPSHOT","class_id":"com-snaplogic-snaps-transform-pivot","class_version":1,"instance_fqid":"84d5fd3d-ba4e-46bc-a64e-3e18fa238846_8","instance_id":"84d5fd3d-ba4e-46bc-a64e-3e18fa238846","instance_version":8,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Pivot - Static"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"targetValueNoPivotsBehavior":{"value":"Substitute null"},"execution_mode":{"value":"Validate & Execute"},"targetFieldFullPath":{"value":true},"fields":{"value":[{"field":{"value":"$Name"},"ifFieldAbsent":{"value":"Substitute empty string"}},{"field":{"value":"$['Last Date Available']"},"ifFieldAbsent":{"value":"Substitute null"}}]},"targetField":{"value":"$Year"},"fieldsAsStatic":{"value":true},"targetValue":{"value":"$Count"},"targetFieldNoPivotsBehavior":{"value":"Substitute null"}},"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"},"392c6bd0-b22c-4d8e-8de7-f60439758ac6":{"class_fqid":"com-snaplogic-snaps-test-assertequals_1-ALL5655","class_id":"com-snaplogic-snaps-test-assertequals","class_version":1,"instance_fqid":"392c6bd0-b22c-4d8e-8de7-f60439758ac6_2","instance_id":"392c6bd0-b22c-4d8e-8de7-f60439758ac6","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Assert Equals"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"evaluateWithInputDocument":{"value":true},"editable_content":{"value":"[{\"Name\":\"David\",\"Last Date Available\":\"2016\",\"Year\":\"2010\",\"Count\":\"90\"},{\"Name\":\"David\",\"Last Date Available\":\"2016\",\"Year\":\"2012\",\"Count\":\"100\"},{\"Name\":\"David\",\"Last Date Available\":\"2016\",\"Year\":\"2014\",\"Count\":\"120\"},{\"Name\":\"David\",\"Last Date Available\":\"2016\",\"Year\":\"2016\",\"Count\":\"140\"},{\"Name\":\"Joseph\",\"Last Date Available\":\"2014\",\"Year\":\"2010\",\"Count\":\"90\"},{\"Name\":\"Joseph\",\"Last Date Available\":\"2014\",\"Year\":\"2012\",\"Count\":\"160\"},{\"Name\":\"Joseph\",\"Last Date Available\":\"2014\",\"Year\":\"2014\",\"Count\":\"220\"},{\"Name\":\"Joseph\",\"Last Date Available\":\"2014\",\"Year\":\"2016\",\"Count\":\"200\"},{\"Name\":\"Roy\",\"Last Date Available\":\"2014\",\"Year\":\"2010\",\"Count\":\"85\"},{\"Name\":\"Roy\",\"Last Date Available\":\"2014\",\"Year\":\"2012\",\"Count\":\"120\"},{\"Name\":\"Roy\",\"Last Date Available\":\"2014\",\"Year\":\"2014\",\"Count\":\"210\"},{\"Name\":\"Roy\",\"Last Date Available\":\"2014\",\"Year\":\"2016\",\"Count\":\"150\"}]"},"execution_mode":{"value":"Validate & Execute"}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{}},"class_build_tag":"ALL5655"}},"path_id":"/QA/TousifDemo/SNAP-9429 - Pivot","path_snode":"62be8c002445576967ba43ea","target_runtime":"standard"}