[ { "op": "core/column-rename", "description": "Rename column Google CZ to KW", "oldColumnName": "Google CZ", "newColumnName": "KW" }, { "op": "core/column-addition", "description": "Create column Pozice Google CZ at index 1 based on column KW using expression grel:forEach(cross(cell,\"collabim-20171012-google-seznam\",\"KW\"),v,v.cells[\"Pozice Google CZ\"].value)[0]", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "Pozice Google CZ", "columnInsertIndex": 1, "baseColumnName": "KW", "expression": "grel:forEach(cross(cell,\"collabim-20171012-google-seznam\",\"KW\"),v,v.cells[\"Pozice Google CZ\"].value)[0]", "onError": "set-to-blank" }, { "op": "core/column-addition", "description": "Create column Pozice Seznam.cz at index 2 based on column KW using expression grel:forEach(cross(cell,\"collabim-20171012-google-seznam\",\"KW\"),v,v.cells[\"Pozice Seznam.cz\"].value)[0]", "engineConfig": { "mode": "row-based", "facets": [] }, "newColumnName": "Pozice Seznam.cz", "columnInsertIndex": 2, "baseColumnName": "KW", "expression": "grel:forEach(cross(cell,\"collabim-20171012-google-seznam\",\"KW\"),v,v.cells[\"Pozice Seznam.cz\"].value)[0]", "onError": "set-to-blank" }, { "op": "core/column-rename", "description": "Rename column Pozice Google CZ to Pozice Google CZ (12.10.2017)", "oldColumnName": "Pozice Google CZ", "newColumnName": "Pozice Google CZ (12.10.2017)" }, { "op": "core/column-rename", "description": "Rename column Pozice Seznam.cz to Pozice Seznam.cz (12.10.2017)", "oldColumnName": "Pozice Seznam.cz", "newColumnName": "Pozice Seznam.cz (12.10.2017)" }, { "op": "core/column-rename", "description": "Rename column Pozice Seznam.cz (12.10.2017) to Seznam (12.10.2017)", "oldColumnName": "Pozice Seznam.cz (12.10.2017)", "newColumnName": "Seznam (12.10.2017)" }, { "op": "core/column-rename", "description": "Rename column Pozice Google CZ (12.10.2017) to Google (12.10.2017)", "oldColumnName": "Pozice Google CZ (12.10.2017)", "newColumnName": "Google (12.10.2017)" }, { "op": "core/column-move", "description": "Move column Seznam (12.10.2017) to position 4", "columnName": "Seznam (12.10.2017)", "index": 4 }, { "op": "core/column-move", "description": "Move column Google (12.10.2017) to position 2", "columnName": "Google (12.10.2017)", "index": 2 }, { "op": "core/text-transform", "description": "Text transform on cells in column Google (3.10.2017) using expression grel:value.replace(\"60+\",\"60\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Google (3.10.2017)", "expression": "grel:value.replace(\"60+\",\"60\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Google (12.10.2017) using expression grel:value.replace(\"60+\",\"60\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Google (12.10.2017)", "expression": "grel:value.replace(\"60+\",\"60\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Seznam (3.10.2017) using expression grel:value.replace(\"60+\",\"60\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Seznam (3.10.2017)", "expression": "grel:value.replace(\"60+\",\"60\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Seznam (12.10.2017) using expression grel:value.replace(\"60+\",\"60\")", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Seznam (12.10.2017)", "expression": "grel:value.replace(\"60+\",\"60\")", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Google (3.10.2017) using expression value.toNumber()", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Google (3.10.2017)", "expression": "value.toNumber()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Google (12.10.2017) using expression value.toNumber()", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Google (12.10.2017)", "expression": "value.toNumber()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Seznam (3.10.2017) using expression value.toNumber()", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Seznam (3.10.2017)", "expression": "value.toNumber()", "onError": "keep-original", "repeat": false, "repeatCount": 10 }, { "op": "core/text-transform", "description": "Text transform on cells in column Seznam (12.10.2017) using expression value.toNumber()", "engineConfig": { "mode": "row-based", "facets": [] }, "columnName": "Seznam (12.10.2017)", "expression": "value.toNumber()", "onError": "keep-original", "repeat": false, "repeatCount": 10 } ]