Hi,

I’m trying
to transpose the following table from SQL Server:

Into this
table (first row as column name):

Using this article,
I’m able to transpose the table into (column name like A-G): https://knowledge.safe.com/articles/31701/transpose-a-table-using-fme.html

But for
further use the column name must be the first row, not A-G.

How can I set
first row as column name?

I’ve tried
using the AttributeCreator with values from a second list, and exposing the
dynamic attributes afterword’s, but I can’t get it to work..

Attribute name from list example:

New
Attribute = @Value(_testpara_attri{0}._testpara_value)

Attribute
value = attrs{0}._attr_value

Where _testpara_attri{}
is the list with column names, and attrs{} is the list from the transpose routine.

Workspace: