Transpose Trasnformation

[#1]

Hi all ,

I have around 100 metrics  in [Metric Name] field/column  i want to transpose each metric into column for a straight table use.

And the table is already in QVD, when i try to transpose with 'Enable Transformation Step'  application is freezing .

Please suggest me.

[kmswetha]

Hi,

After loading from QVD, use cross table function.

[kmswetha]

Hi,

me again.

You should be using generic function not crosstab once loaded from qvd.

Here is the syntax

generic load name, metric_name, (Vaue filed which ever is numeric) resident table_name;

[#4]

Application is freezing.. Swetha

[qlikviewwizard]

Hi krrushna

Instead of loading , just edit script and run in debug mode by giving less no of rows.

Hope this will help you.

[#6]

Its not working as expected..

[qlikviewwizard]

Can you attach the sample file.

[#8]

Attached sample file

[qlikviewwizard]

Hi krrushna

Remove F column and second row in transformation. I used Sheet2.

Please check again. Let me know if any issues.

[#10 · Accepted solution]

I tried this way in script. It worked for me.also i need to create this way for all other metrics.. with concatenation.

Temp:

ID,

[Updated On] as N_Updated_On,

[Value Before Update] as N_MCost Actual $

Resident [Tablename]

where [Metric Name]='MCost Actual $';

Thanks for all your suggestions.