Converting Table Headers to First Row of Data Set (not at Import)

[MTecovis]

Hey guys,

I'm just trying to get my headers as my first row of the data set.

This is not an issue for an import function (there it's a simple check), but within a workflow I couldn't figure it out so far.

Origin:

A - B - C - D

1 - 2 -  3 - 4

Aim:

Field1 - Field2 - Field3 - Field4

   A      -    B     -     C    -     D

   1      -    2     -      3    -     4

Maybe it's just a simple thing, but couldn't find it so far :/

Thanks for your help in advance.

Greetings

[BenoitC]

Hello,

I found a solution with transpose and recordID. See below:

Let me know if this works!

[MTecovis]

Hey @BenoitC

thanks for the fast reply :)

I liked the idea behind your workflow,

but sadly your workflow seems to work well only for just one line in the original data set,

I just tried to simplify the problem.

In fact my dataset has 124 columns and about 50,000 lines, so when I tried your idea with my data set, it sadly didn't work.

So in the Transpose function it generates millions of lines in just 2 columns, and when i try to cross-tab the data back it says there is no data availabe.

But still thank you very much

[BenoitC · Accepted solution]

This solution doesn't rely on using transpose, just field summary, so you don't need to manipulate the whole 50K lines:

[MTecovis]

Hey Benoit,

thanks again for the fast reply!

With your second message I just recognized your first answer was nearly the goal already! :)

Your first solution is completeley fine, as long as I just take a "Select Records" tool (with only 1 record taken) in front and add it via Unique to the data itself

So to be fair, I think both solutions you mentioned will work accurately :)

Thank you very much

BR

[BenoitC]

You're welcome ! Enjoy :)