Autodetect columns name after tPivotToColumnsDelimited

[Anonymous]

Hi Talend Community,

I'm using a tPivotToColumnsDelimited to transpose rows to columns. It writes the result in a delimitedFile.

I need to keep working on the datas so i use a tInputDelimitedFile to getthe datas back in the flow. 

My problem is that, actually, i'm filling the tInputDelimitedFile schema manually but it may change.

So what i want is to detect the columns created per the tPivotToColumnsDelimited and their order, to automatically fill the tInputDelimitedFile schema.

Thank you in advance !

[Anonymous]

tFileInputDelimiter does'nt consider the names of the columns, it only consider the order of records in your file

I suggest you create a schema with the maximun number of columns
column1, column2, ......

[Anonymous]

Thank you DMG for your answer but i actually need the names.

I joined the file that i get from the tPivotToColumnDelimited. 

date, entreprojet,totaltime and timeh are fixed.

But the rest can change. 

And what i'm doing is that after writing this file, i open it with a tfiledelimited and rewrite it into an excel file. 

I need the column name and in the same order, or the number won't be the same.

Best regards

entreeProjet.csv