Allow Null Values on CSV Reader

naveenn08 · February 8, 2023, 11:49pm

Hi All,

I’m trying to use a CSV Reader to read a dataset which has Partial Null Values in few columns and the CSV reader keep failing due to Null values. How can I override this issue and allow the data to flow through.
.

elsamuel · February 9, 2023, 12:15am

Welcome to the forum @naveenn08.

Have you tried selecting the option to support short data rows?

naveenn08 · February 9, 2023, 9:47pm

I tried that option but it still didn’t work

ArjenEX · February 9, 2023, 10:55pm

What error message do you get?

Because based on your screenshot it looks like it’s loading fine. If the problem persists it’s recommend to upload an (anonymized) small sample file outline the problem so that people can help you more effectively.

system · May 10, 2023, 10:55pm

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.