topic Autodetect columns name after tPivotToColumnsDelimited in Talend Studio

Autodetect columns name after tPivotToColumnsDelimited

Anonymous — Wed, 19 Jun 2019 10:36:05 GMT

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 !

Re: Autodetect columns name after tPivotToColumnsDelimited

Anonymous — Wed, 19 Jun 2019 16:24:42 GMT

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, ......

Re: Autodetect columns name after tPivotToColumnsDelimited

Anonymous — Wed, 19 Jun 2019 16:57:37 GMT

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