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
Solved! Go to Solution.
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
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
You're welcome ! Enjoy :)