Delete first row/set second row as header

gracewei

Hi, I just transposed my data table which created a row of new header. However, I want to delete the new created header, and use the second row as my header. How could I do that? 

Jeff_Mergler

Hi @gracewei, I think you are looking for the Rename by Example Values operator. You just select the row number and it will use the values from that row as the new attribute names. If I've misunderstood what you want to do, please post a simple example.

Jeff_Mergler

Hi @gracewei, I think you are looking for the Rename by Example Values operator. You just select the row number and it will use the values from that row as the new attribute names. If I've misunderstood what you want to do, please post a simple example.

gracewei

@jmergler Thank you so much! That worked perfectly! 

iven

It works when I check the result, but when I use select attributes after this operator, it still shows the old columns name.