Transform record to columns

[Istwineres]

Hi all, I'm looking for a solution to transform records in columns. My desidered output would be a column for each element on code column and group by value's record

value    PERF365_ITD_N    Perf_MTD_N  ...... bmk    bmkpef

  xyz        0.380054                 -0.01811             bmk1   -0.00037

Many thanks!

[mceleavey]

Hi @Istwineres ,

this is a simple crosstab function:

I've attached the workflow.

M.

[Istwineres]

May I ask you why Sum as method for Aggregating Values? Thanks!

[KarolinaRoza]

Hi @Istwineres,

please find solution for your problem.

I applied cross-tab tool together with summary tool to include all your desired columns.

Let me know it it is something you look for.

Kind Regards,

Karolina

[Kurohits]

Checkout my solution...Easy to follow

[mceleavey]

Hi @Istwineres ,

It doesn't matter what the aggregate function is because it will always be aggregated to a single row. You can use any in this regard 🙂

M.

[Istwineres]

I didn't know that!