akvo / akvo-lumen

Make sense of your data
https://akvo.org/akvo-lumen
GNU Affero General Public License v3.0
63 stars 18 forks source link

engine/adapt-transformation fails for derive op #3102

Closed tangrammer closed 3 years ago

tangrammer commented 3 years ago

Context

https://akvoo.reamaze.com/admin/conversations/akvolumen-support-request-number-492211-from-irene-at-akvo-dot-org

Failed to update "Schools 2021: merged registration & monitoring". Failed to update due to transformation mismatch: Failed to transform: There is more than one column with this name: 'Surveyal time', Js code needs to reference the column with the group. Eg: row['Transformations']['Surveyal time'] . TX: {"op" "core/derive", "args" {"code" "Math.round((row['Surveyal time']+row['Transformations']['Surveyal time'])/60)", "newColumnType" "number", "newColumnTitle" "Average survey time"}, "created" "2021-03-29T10:22:28.810Z", "onError" "leave-empty", "changedColumns" {"d51" {"after" {"sort" nil, "type" "number", "title" "Average survey time", "hidden" false, "direction" nil, "columnName" "d51"}, "before" nil}}}

Problem or idea clojure

:before :engine/adapt-transformation 

{"op" "core/derive", "args" {"code" "Math.round((row['Metadata']['Surveyal time']+row['Transformations']['Surveyal time'])/60)", "newColumnType" "number", "newColumnTitle" "yyyy"}, "created" "2021-03-29T11:37:28.928Z", "onError" "leave-empty", "changedColumns" {"d4" {"after" {"sort" nil, "type" "number", "title" "yyyy", "hidden" false, "direction" nil, "columnName" "d4"}, "before" nil}}}
:after :engine/adapt-transformation
{"op" "core/derive", "args" {"code" "Math.round((row['Surveyal time']+row['Transformations']['Surveyal time'])/60)", "newColumnType" "number", "newColumnTitle" "yyyy"}, "created" "2021-03-29T11:37:28.928Z", "onError" "leave-empty", "changedColumns" {"d4" {"after" {"sort" nil, "type" "number", "title" "yyyy", "hidden" false, "direction" nil, "columnName" "d4"}, "before" nil}}}

Solution or next step

How could we solve it?