When using the Extract rows from a CSV file board in pipeline builder, it fails to keep the order of the headers when you are autogenerating a schema from an example.
The order of the columns in the board output matches that of the schema defined below the example data, causing data to be in the wrong columns.
Here is an example screenshot:
Hey thanks for bringing this to our attention! It looks like this is a bug that affects column titles that being with numbers. We’ll look into this and update the issue when it’s fixed.
As a workaround in the meantime, you can select or re order the columns after extracting the rows from the CSV file using the select columns board
Hi, thanks for flagging this issue! We’ve made a fix and you should see this reflected in your pipeline in the next few days. Please let us know if there are any further issues here, or elsewhere – we appreciate the feedback!
