Transpose

[#1]

Hi All,

I need to transpose the Metric field  values to column vise any suggestion.

[sunny_talwar]

Transpose them on the front end or the script?

[sunny_talwar]

For front end option, you can do like this:

• Create a straight table
• Add Metric Name, Project ID, Project Name, Updated On, Value Before Update as Dimensions
• Create 1 as expression
• On Presentation tab Hide 1 as expression and select Horizontal check box (attaching a screenshot for this one)

Output:

HTH

Best,

Sunny

[#4]

Thankyou,

It need to be hardcoded in script Level.

Expected result is

[avinashelite · Accepted solution]

Please find the attachment for the same

[petter]

If you are looking for a solution where you transpose (un-pivot) the table in the load script then this could be a solution for you:

I had to make your XLSX-sample conformant with your expected results so I attached a new XLSX-file too...

[#7]

Hi Petter,

if i have multiple entries for same metric for same project the logic used is not working for straight table. am looking for result in straight table.