You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
At the moment, the flattened version of submitted BODS 0.4 data isn't quite right. If you run this file through the tool, you'll see that there is no 'statementId' column on sheets 2 - 5 which would be needed to join the rows with the relevant rows on sheet 1.
Suggested fix
The problem is that the parameters passed to flatten-tool here are those for 0.3 and earlier. For 0.4, I think that id_name and root_id need to be 'statementId' and not 'statementID'.
The text was updated successfully, but these errors were encountered:
Yes - let's ultimately test this @radix0000 by round-tripping some data from JSON -> xlsx -> JSON and checking that the checks give the same output along the way.
The obvious issues with this round trip in BODS 0.3 are the booleans (true/false in JSON) end up being strings of the Python boolean names ("True"/"False"), and also keys with a value of an empty list disappear along the way.
Bug description
At the moment, the flattened version of submitted BODS 0.4 data isn't quite right. If you run this file through the tool, you'll see that there is no 'statementId' column on sheets 2 - 5 which would be needed to join the rows with the relevant rows on sheet 1.
Suggested fix
The problem is that the parameters passed to flatten-tool here are those for 0.3 and earlier. For 0.4, I think that id_name and root_id need to be 'statementId' and not 'statementID'.
The text was updated successfully, but these errors were encountered: