tFileOutputParquet - java.lang.NullPointerException: name should not be null

[TalendSolutionExpert]

[Background]
-Talend Studio 7.3.1 or Talend Studio 8.0.1

[Problem]
-We have a workflow to convert Excel files to parquet,tFileInputExcel with dynamic


-Run the job, and it gives us: name should not be null


[Reason]
-There are some empty columns in the source Excel file:


[Workaround]

-For the tFileInputExcel dynamic, It needs the first line to guess the schema.

-The example job source Excel didn't set a real header. Please Add tJavaFlex to transform Dynamic metadata with:

To the start code:

boolean isFirst = true; 

To the main code:

if(isFirst) {
  isFirst = false;
  Dynamic newDyn = row1.newColumn.clone(false);
  for(DynamicMetadata meta : newDyn.metadatas) {
            // reset column name,
            String newColumnName = "field"+meta.getColumnPosition();
            meta.setName(newColumnName);
            meta.setDbName(newColumnName);            
            System.out.println("New  dynamic field name: '"+ meta.getDbName()+"' ");
  }
  row2.newColumn = newDyn;
} 

After that, the job works.