{"contentType":"domo/dataflow-actions","data":[{"icon":"select-columns","name":"Select Columns","category":"utility","description":"Select what columns to include, change their order and optionally rename them.","type":"SelectValues","config":{"curView":"configuration","maxTargets":1,"hasSources":true,"hasTargets":true},"helpUrl":"/articles/360044876874#5.","dirtyPreview":false,"previewRunning":false,"removeByDefault":false,"configured":true,"ready":true,"enabled":true,"selectedTabHasMessage":false,"dependsOn":["3aa9fd9c-aba2-4005-aeab-678e98c3ad7e"],"children":["42eba687-42fa-449e-917b-3ed3f3a74e04"],"outputSchema":[{"name":"Year","id":"Year","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}}],"previewData":{},"gui":{"x":144,"y":240,"color":null,"colorSource":null,"sampleJson":null},"notes":[],"fields":[{"name":"y","rename":"Year","type":null,"dateFormat":null,"settings":null,"remove":false}],"id":"d43b8305-36fc-441b-ad1a-8e297922e287","label":"Select Columns","data":[["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"],["2010"]]},{"icon":"remove-duplicates","name":"Remove Duplicates","category":"filter","description":"Remove duplicate rows based on specific columns.","type":"Unique","config":{"curView":"configuration","maxTargets":1,"hasSources":true,"hasTargets":true},"helpUrl":"/articles/360044876614#4.","dirtyPreview":false,"previewRunning":false,"removeByDefault":false,"configured":true,"ready":true,"enabled":true,"selectedTabHasMessage":false,"dependsOn":["d43b8305-36fc-441b-ad1a-8e297922e287"],"children":["c4fcd3e1-a8b4-4044-a146-c8f751e93654"],"outputSchema":[{"name":"Year","id":"Year","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}}],"previewData":{},"gui":{"x":264,"y":240,"color":null,"colorSource":null,"sampleJson":null},"notes":[],"countRows":false,"partitionedAggregation":false,"fields":[{"name":"Year","caseInsensitive":false}],"id":"42eba687-42fa-449e-917b-3ed3f3a74e04","label":"Remove Duplicates","data":[["2010"]]},{"icon":"expression-evaluator","name":"Add Formula","category":"utility","description":"Create a new column, or modify existing columns, using SQL-style expressions","type":"ExpressionEvaluator","config":{"curView":"configuration","maxTargets":1,"hasSources":true,"hasTargets":true},"helpUrl":"/articles/360044876874#3.","searchTags":["Beastmode"],"dirtyPreview":false,"previewRunning":false,"removeByDefault":false,"configured":true,"ready":true,"enabled":true,"selectedTabHasMessage":false,"dependsOn":["8de50e5a-5e77-4cf1-ac65-c16f413d8373"],"children":["57eac862-4679-4094-985c-08146908615e"],"outputSchema":[{"name":"START YEAR","id":"START YEAR","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"END YEAR","id":"END YEAR","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"NOTE","id":"NOTE","type":"STRING","typeLabel":"Text","icon":"icon-abc","metadata":{}},{"name":"34685b32-005b-4ff0-87d9-3520c0e0ac26_PREVIEW_0","id":"34685b32-005b-4ff0-87d9-3520c0e0ac26_PREVIEW_0","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"Join Column","id":"Join Column","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}}],"previewData":{},"gui":{"x":144,"y":96,"color":null,"colorSource":null,"sampleJson":null},"notes":[],"expressions":[{"expression":"1","fieldName":"Join Column","settings":{},"valid":true}],"id":"34685b32-005b-4ff0-87d9-3520c0e0ac26","columnSettings":{"Join Column":{}},"label":"Add Formula","data":[["2013","2018","1st Note","1","1"],["2019","2023","2nd Note","1","1"]]},{"icon":"expression-evaluator","name":"Add Formula 1","category":"utility","description":"Create a new column, or modify existing columns, using SQL-style expressions","type":"ExpressionEvaluator","config":{"curView":"configuration","maxTargets":1,"hasSources":true,"hasTargets":true},"helpUrl":"/articles/360044876874#3.","searchTags":["Beastmode"],"dirtyPreview":false,"previewRunning":false,"removeByDefault":false,"configured":true,"ready":true,"enabled":true,"selectedTabHasMessage":false,"dependsOn":["42eba687-42fa-449e-917b-3ed3f3a74e04"],"children":["57eac862-4679-4094-985c-08146908615e"],"outputSchema":[{"name":"Year","id":"Year","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"c4fcd3e1-a8b4-4044-a146-c8f751e93654_PREVIEW_0","id":"c4fcd3e1-a8b4-4044-a146-c8f751e93654_PREVIEW_0","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"Join Column","id":"Join Column","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}}],"previewData":{},"gui":{"x":372,"y":240,"color":null,"colorSource":null,"sampleJson":null},"notes":[],"expressions":[{"expression":"1","fieldName":"Join Column","settings":{},"valid":true}],"id":"c4fcd3e1-a8b4-4044-a146-c8f751e93654","columnSettings":{"Join Column":{}},"label":"Add Formula","data":[["2010","1","1"]]},{"icon":"inner-join","name":"Join Data","category":"combine-data","description":"Combine rows from two DataSets into one.","type":"MergeJoin","helpUrl":"/articles/360044876194#3.","config":{"curView":"configuration","maxTargets":2,"minTargets":2,"hasSources":true,"hasTargets":true},"dirtyPreview":false,"previewRunning":false,"removeByDefault":false,"configured":true,"ready":true,"enabled":true,"selectedTabHasMessage":false,"dependsOn":["34685b32-005b-4ff0-87d9-3520c0e0ac26","c4fcd3e1-a8b4-4044-a146-c8f751e93654"],"children":["a1dea303-8a88-41b1-81e9-8e865bdab54d"],"outputSchema":[{"name":"START YEAR","id":"START YEAR","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"END YEAR","id":"END YEAR","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"NOTE","id":"NOTE","type":"STRING","typeLabel":"Text","icon":"icon-abc","metadata":{}},{"name":"34685b32-005b-4ff0-87d9-3520c0e0ac26_PREVIEW_0","id":"34685b32-005b-4ff0-87d9-3520c0e0ac26_PREVIEW_0","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"Year","id":"Year","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"c4fcd3e1-a8b4-4044-a146-c8f751e93654_PREVIEW_0","id":"c4fcd3e1-a8b4-4044-a146-c8f751e93654_PREVIEW_0","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}}],"previewData":{},"gui":{"x":540,"y":156,"color":null,"colorSource":null,"sampleJson":null},"notes":[],"step1":"34685b32-005b-4ff0-87d9-3520c0e0ac26","step2":"c4fcd3e1-a8b4-4044-a146-c8f751e93654","joinType":"INNER","keys1":["Join Column"],"keys2":["Join Column"],"schemaModification1":[{"name":"Join Column","rename":"","remove":true}],"schemaModification2":[{"name":"Join Column","rename":"","remove":true}],"id":"57eac862-4679-4094-985c-08146908615e","label":"Join Data","data":[["2013","2018","1st Note","1","2010","1"],["2019","2023","2nd Note","1","2010","1"]]},{"icon":"filter-rows","name":"Filter Rows","category":"filter","description":"Include or exclude rows based on defined rules.","type":"Filter","config":{"curView":"configuration","maxTargets":1,"hasSources":true,"hasTargets":true},"helpUrl":"/articles/360044876614#3.","dirtyPreview":false,"previewRunning":false,"removeByDefault":false,"configured":true,"ready":true,"enabled":true,"selectedTabHasMessage":false,"dependsOn":["57eac862-4679-4094-985c-08146908615e"],"children":["7d8042ff-5d6e-48b3-8c1c-26dd97c712b1"],"outputSchema":[{"name":"START YEAR","id":"START YEAR","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"END YEAR","id":"END YEAR","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"NOTE","id":"NOTE","type":"STRING","typeLabel":"Text","icon":"icon-abc","metadata":{}},{"name":"34685b32-005b-4ff0-87d9-3520c0e0ac26_PREVIEW_0","id":"34685b32-005b-4ff0-87d9-3520c0e0ac26_PREVIEW_0","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"Year","id":"Year","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"c4fcd3e1-a8b4-4044-a146-c8f751e93654_PREVIEW_0","id":"c4fcd3e1-a8b4-4044-a146-c8f751e93654_PREVIEW_0","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}}],"previewData":{},"gui":{"x":660,"y":156,"color":null,"colorSource":null,"sampleJson":null},"notes":[],"filterList":[{"leftField":null,"rightField":null,"rightValue":null,"rightExpr":null,"operator":null,"expression":"`Year` >= `START YEAR` AND `Year` <= `END YEAR`","andFilterList":[],"exprValid":true}],"id":"a1dea303-8a88-41b1-81e9-8e865bdab54d","ruleCondition":"AND","label":"Filter Rows"},{"icon":"select-columns","name":"Select Columns 1","category":"utility","description":"Select what columns to include, change their order and optionally rename them.","type":"SelectValues","config":{"curView":"configuration","maxTargets":1,"hasSources":true,"hasTargets":true},"helpUrl":"/articles/360044876874#5.","dirtyPreview":false,"previewRunning":false,"removeByDefault":false,"configured":true,"ready":true,"enabled":true,"selectedTabHasMessage":false,"dependsOn":["a1dea303-8a88-41b1-81e9-8e865bdab54d"],"children":["b3ea8b88-b896-455e-907b-43de23f63591"],"outputSchema":[{"name":"Year","id":"Year","type":"LONG","typeLabel":"Integer","icon":"icon-numbers","metadata":{}},{"name":"NOTE","id":"NOTE","type":"STRING","typeLabel":"Text","icon":"icon-abc","metadata":{}}],"previewData":{},"gui":{"x":768,"y":156,"color":null,"colorSource":null,"sampleJson":null},"notes":[],"fields":[{"name":"Year","rename":"","type":null,"dateFormat":null,"settings":null,"remove":false},{"name":"NOTE","rename":"","type":null,"dateFormat":null,"settings":null,"remove":false}],"id":"7d8042ff-5d6e-48b3-8c1c-26dd97c712b1","label":"Select Columns"}]}