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

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

Workflow

Developer

Tips and Tricks

Accepted answers

BenoitC

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

Header_as_row.yxmd

All comments

BenoitC

Hello,

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

Let me know if this works!

Header_as_row.yxmd

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

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

Header_as_row.yxmd

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

BenoitC

You're welcome ! Enjoy

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703