{"contentType":"domo/dataflow-actions","data":[{"name":"TEST_Delete","id":"7433ebf7-086e-4024-89bc-9c42e195be55","type":"LoadFromVault","gui":{"x":36,"y":180,"color":3238043,"colorSource":null},"dependsOn":[],"removeByDefault":false,"notes":[],"dataSourceId":"b974593c-e1bd-4fe5-b436-2f6fc641a9d6","executeFlowWhenUpdated":false,"onlyLoadNewVersions":false,"columnSettings":{},"visiblePartitionColumn":null,"versionWindow":null},{"name":"Split Column","id":"31e0a5ee-8fef-4325-ac52-83dc47c23267","type":"SplitColumnAction","gui":{"x":144,"y":180,"color":null,"colorSource":null},"dependsOn":["7433ebf7-086e-4024-89bc-9c42e195be55"],"removeByDefault":false,"notes":[],"sourceColumn":"Property","delimiterType":"CUSTOM","delimiter":"(","useRegex":false,"combineExtraSplits":false,"additions":[{"name":"Activity Keep","dataType":"STRING"},{"name":"Activity Drop","dataType":"STRING"}]},{"name":"Alter Columns","id":"559e0a99-2d51-48cb-874c-b8f3e3ba3dbd","type":"Metadata","gui":{"x":252,"y":180,"color":null,"colorSource":null},"dependsOn":["31e0a5ee-8fef-4325-ac52-83dc47c23267"],"removeByDefault":false,"notes":[],"fields":[{"name":"Activity Drop","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true}]},{"name":"Add Formula","id":"9e107c26-0bd9-4240-b7ec-f00d9188fc3a","type":"ExpressionEvaluator","gui":{"x":360,"y":180,"color":null,"colorSource":null},"dependsOn":["559e0a99-2d51-48cb-874c-b8f3e3ba3dbd"],"removeByDefault":false,"notes":[],"expressions":[{"expression":"CASE WHEN LEFT(`Property` , 8) = 'Property' THEN `Property` END","fieldName":"Property?","settings":null},{"expression":"CASE WHEN LEFT(`Property` , 8) = 'Activity' THEN `Activity Keep` END","fieldName":"Activity?","settings":null}]},{"name":"Add Constants","id":"4307b391-f172-438a-b4bf-55e3803ef24e","type":"Constant","gui":{"x":456,"y":180,"color":null,"colorSource":null},"dependsOn":["9e107c26-0bd9-4240-b7ec-f00d9188fc3a"],"removeByDefault":false,"notes":[],"fields":[{"name":"Constant","type":"LONG","expr":null,"value":"1"}]},{"name":"Rank & Window","id":"23cbfd2a-f32b-4670-9b09-bafb1e15e6a7","type":"WindowAction","gui":{"x":576,"y":180,"color":null,"colorSource":null},"dependsOn":["4307b391-f172-438a-b4bf-55e3803ef24e"],"removeByDefault":false,"notes":[],"partitionedAggregation":false,"additions":[{"name":"Property_ID","operation":{"type":"FRAMED","operationType":"COUNT","column":"Property?","preceding":null,"following":0}}],"orderRules":[{"column":"ROW","caseSensitive":false,"ascending":true}],"groupRules":[{"column":"Constant","caseSensitive":false}]},{"name":"Filter Rows","id":"3d8c4a4f-e482-4323-920e-fba520d6a532","type":"Filter","gui":{"x":684,"y":96,"color":null,"colorSource":null},"dependsOn":["23cbfd2a-f32b-4670-9b09-bafb1e15e6a7"],"removeByDefault":false,"notes":[],"filterList":[{"expression":"`Property?` is not null","andFilterList":[]}]},{"name":"Alter Columns 1","id":"228a5476-6dfd-4e7d-8d7e-9a2c43c15209","type":"Metadata","gui":{"x":780,"y":96,"color":null,"colorSource":null},"dependsOn":["3d8c4a4f-e482-4323-920e-fba520d6a532"],"removeByDefault":false,"notes":[],"fields":[{"name":"Property","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"Activity Keep","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"Constant","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"PProperty_Lookup_Code","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"Bldg_unit","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"Activity?","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"Property_ID","rename":"Property_ID_Join","type":null,"dateFormat":null,"settings":null,"remove":false},{"name":"ROW","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true}]},{"name":"Join Data","id":"dff7690e-28d2-4b85-9483-4d8f7136b0fc","type":"MergeJoin","gui":{"x":900,"y":180,"color":null,"colorSource":null},"dependsOn":["23cbfd2a-f32b-4670-9b09-bafb1e15e6a7","228a5476-6dfd-4e7d-8d7e-9a2c43c15209"],"removeByDefault":false,"notes":[],"joinType":"LEFT OUTER","step1":"23cbfd2a-f32b-4670-9b09-bafb1e15e6a7","step2":"228a5476-6dfd-4e7d-8d7e-9a2c43c15209","keys1":["Property_ID"],"keys2":["Property_ID_Join"],"schemaModification1":[],"schemaModification2":[{"name":"Property_ID_Join","rename":"","remove":true},{"name":"Property?","rename":"Property_Name","remove":false}],"partitioningInputId":""},{"name":"Rank & Window 1","id":"f4b9ecb8-7715-4b86-b397-be464e819872","type":"WindowAction","gui":{"x":1002,"y":180,"color":null,"colorSource":null},"dependsOn":["dff7690e-28d2-4b85-9483-4d8f7136b0fc"],"removeByDefault":false,"notes":[],"partitionedAggregation":false,"additions":[{"name":"Activity_ID","operation":{"type":"FRAMED","operationType":"COUNT","column":"Activity?","preceding":null,"following":0}}],"orderRules":[{"column":"ROW","caseSensitive":false,"ascending":true}],"groupRules":[{"column":"Constant","caseSensitive":false},{"column":"Property_Name","caseSensitive":false}]},{"name":"Filter Rows 1","id":"6e7d456e-ee0a-461e-8be5-ea3fc9e7eb7b","type":"Filter","gui":{"x":1092,"y":312,"color":null,"colorSource":null},"dependsOn":["f4b9ecb8-7715-4b86-b397-be464e819872"],"removeByDefault":false,"notes":[],"filterList":[{"expression":"`Activity?` is not null","andFilterList":[]}]},{"name":"Alter Columns 2","id":"511a027b-7017-46d9-87ef-ca0bac8d87f7","type":"Metadata","gui":{"x":1200,"y":312,"color":null,"colorSource":null},"dependsOn":["6e7d456e-ee0a-461e-8be5-ea3fc9e7eb7b"],"removeByDefault":false,"notes":[],"fields":[{"name":"Property","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"Activity Keep","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"Constant","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"PProperty_Lookup_Code","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"Bldg_unit","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"Activity_ID","rename":"Activity_ID_Join","type":null,"dateFormat":null,"settings":null,"remove":false},{"name":"ROW","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"Property?","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"Property_Name","rename":null,"type":null,"dateFormat":null,"settings":null,"remove":true},{"name":"Activity?","rename":"Activity_Name","type":null,"dateFormat":null,"settings":null,"remove":false},{"name":"Property_ID","rename":"Property_ID_Join","type":null,"dateFormat":null,"settings":null,"remove":false}]},{"name":"Join Data 1","id":"0d04ebba-296e-4a2b-b7b1-725f1e69a9ae","type":"MergeJoin","gui":{"x":1296,"y":180,"color":null,"colorSource":null},"dependsOn":["511a027b-7017-46d9-87ef-ca0bac8d87f7","f4b9ecb8-7715-4b86-b397-be464e819872"],"removeByDefault":false,"notes":[],"joinType":"LEFT OUTER","step1":"f4b9ecb8-7715-4b86-b397-be464e819872","step2":"511a027b-7017-46d9-87ef-ca0bac8d87f7","keys1":["Property_ID","Activity_ID"],"keys2":["Property_ID_Join","Activity_ID_Join"],"schemaModification1":[],"schemaModification2":[{"name":"Activity_ID_Join","rename":"","remove":true},{"name":"Property_ID_Join","rename":"","remove":true}],"partitioningInputId":""},{"name":"Select Columns","id":"5b453fd1-c566-4ae7-aa31-2a18cd3b9e84","type":"SelectValues","gui":{"x":1404,"y":180,"color":null,"colorSource":null},"dependsOn":["0d04ebba-296e-4a2b-b7b1-725f1e69a9ae"],"removeByDefault":false,"notes":[],"fields":[{"name":"ROW","rename":null},{"name":"Property_ID","rename":null},{"name":"Property_Name","rename":null},{"name":"Activity_ID","rename":null},{"name":"Activity_Name","rename":null},{"name":"Property","rename":null},{"name":"PProperty_Lookup_Code","rename":null},{"name":"Bldg_unit","rename":null}]},{"name":"Test_Output","id":"c7396e15-6c4c-46f1-9793-85fa3ffdb455","type":"PublishToVault","gui":{"x":1542,"y":180,"color":null,"colorSource":null},"dependsOn":["5b453fd1-c566-4ae7-aa31-2a18cd3b9e84"],"removeByDefault":false,"notes":[],"dataSource":{"guid":"25885a8d-00e5-4e0f-9d18-d023f55288d1","type":"DataFlow","name":"Test_Output","cloudId":"domo"},"versionChainType":"REPLACE","partitionIdColumns":[],"upsertColumns":[],"retainPartitionExpression":""}]}