Is there a way to see all records with warnings instead of just first 10?

I'm trying to see all records with "too many fields in record #" and "not enough fields in record #" warnings to filter those and analyze them separately. However I can only see the first 10 in the results window. Is there a way to see all of these warnings? Or even filter those records from the data set?

Alteryx_results-jpg.zip

Error Message

Accepted answers

afv2688

And changing the delimiter in the input to < \0 >? this will read the whole file directly without parsing.

You can add then a parse tool to see correctly your data

All comments

afv2688

Have you tried using the browse tool? If it doesnt work the only solution I can think of is to try to open the file in notepad++ and check it there

ebolatkale

I have over 100 million line items, Notepadd++ is not an option to use on my work computer and I'm not sure if I could open the file even if I had it. Browse is not helpful because those records with "too many fields in record #" are truncated even if I locate them in Browse. But the main issue is I don't even see which records have problems other than the first 10 that are listed in the results window, I would like to see all records with those warning messages.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703