Append Column Names to Data Rows

Question

Hi,

I've a Dataset where I want to append column names to the Data.

For example,

BrandProduct11122324

To Be converted to

BrandProductBrand 1Product 1Brand 1Product 2Brand 2Product 3Brand 2Product 4

I'm not able to figure out a way. Any help would be appreciated!

JosephSerpis · Accepted Answer

Hi @vinayR96 I mocked up a workflow that produces your output. Let me know what you think?

meljaafari · Accepted Answer

Hi,

You can leverage the CrossTab and Transpose as a way to bring column headers to rows, concatenate the bring them back to columns.

The record ID at the start is what allows us to still identify every single row within your data.

Here is what the workflow based on your data looks like, and I have attached the sample workflow

I hope this helps,

Cheers,

Mo