Have a DQ job to be created on remote ADLS file CSV file with delimiter '~'. The file throws an error ' trailing quote on quoted field is malformed in row 79' and hence a blocker. How to address this issue? Can we skip the row 79 alone from processing? Tried skip lines options, but it skips the headers too.. wanted the headers and the valid 77 rows as well. How to tackle this ? Thanks in advance

How to skip a specific row in a remote CSV file source from processing since it is malformed | Developers

How to skip a specific row in a remote CSV file source from processing since it is malformed | Developers | Collibra Community