pentaho spoon - How to find columns count of csv(Excel) sheet in ETL? -


to count rows of csv file can use files rows count input in etl. how find number columns of csv file?

just read first row of csv file using text-file-input setting header rows 0. usually, first row contains field names. if read whole row single field, can use split-field-to-rows have single fieldname per row , number of rows tells number of fields. there other ways, 1 prepares subsequent metadata injection - if that's have in mind.


Comments

Popular posts from this blog

'hasOwnProperty' in javascript -

python - ValueError: No axis named 1 for object type <class 'pandas.core.series.Series'> -

java - How to provide dependency injections in Eclipse RCP 3.x? -