Loading all columns in CSV by default in Reader

Using CSV file , assuming my delimiters are correct , my line terminators are correct , my encoding is correct , whenever I try to open a CSV file , why can't all the non empty columns be loaded by default ? I understand I can right click and increase the number of columns , but surely I am missing a checkbox which should do it by self.

I recently tried loading a file with 35 columsn and I thought it had 24 , and so I increased one by one by one by one by one by one by one by one by one by one by one by one ( one extra so I had to delete) .. 

For a change , I am seeing even XLS files are treated similar to above

Right click and select auto-format-grid

www.etl-tools.com/wiki/advanced-etl-proc...reader-sources/text/

 

Peter.Jonson wrote:

 

My Big fat thanks for attaching this screenshot !! This is legit very very helpful 

This behaviour is not present in WRITER .

it could be helpful in cases  output is known (when existing workflows are being shifted to ETL-tools)

Not sure that it is necessary.

You can copy fields from reader to writer and you can even swap reader and writer (There a button for it)

I personally do not use "Take filed names" option because there always a danger of selecting incorrect file and loosing some of the mapping.
(But that is my opinion).