Change Column Header name

[ravi13]

Hi!! Knime Expert Hope you are doing well.

I am facing following issue…

TABLE:1

BELNR	KUNNR	KTOKK	MANDT
89	23	75	97
90	50	98	75
53	23	23	96

TABLE:2

BELNR	KTOKK
Doc. No	Vendor Group

Required Output:

Doc. No	Vendor Group
89	75
90	98
53	23

Please help me to develop workflow.

Thanks in Advance.

[tommy]

hi @ravi13,

you should use the Transpose Node for Table 2 and then it’s the Insert Column Header Node. Should be configured like shown here…

Hope this helps, Greetz, Tommy

[ravi13]

@tommy
thanks for your response.

As of now I am using Table creator for Table 2.

I can put data in any format, but my concern is that data is coming from Table1 in technical name and in Table 2 i have technical name which is limited means … data is coming for 100 column but my requirement is of 10 column only and i want replace that technical name with functional name.

Please guide me.

[AnotherFraudUser]

maybe that will help:

Choose a specific row as header

Dear all, I met a challenge that choose a certain row as the head of the table. I know that the “Extract Column Header” & “Insert Column Header” will be applied in this situation, however I try many times, still can not figure out. so I will appreciate the help to show me the way . it would be better to attached the workflow. [Annotation 2020-06-10 224007] this is the table I read, and I plan to use row 0, (A,B,C,D) as the header of the table. Highly appreciate your supporting ! Kevin

[tommy]

Yes, my table creator substitutes your Table 2.
And it’s possible to refer only a specific amount of columns in Table 2. The other columns will stay as they are (the option “Fail if no assignment” has to be unchecked). You can filter them with the help of the Column filter Node.

[ravi13]

@AnotherFraudUser
Thanks for reply, but what i think is this would not work if sequence is not maintain.

[ravi13]

@tommy
can you share your workflow if possible.

[AnotherFraudUser]

hi @ravi13,

attached two examples which should work for you:
KNIME_project19.knwf (20.1 KB) KNIME_project20.knwf (10.6 KB)

You could also try to loop through your columns and rename them one by one