Display rows as columns and viceversa using Script

[Anonymous]

Hi all,

    I am loading data from QVD's and the user wants the values to be displayed in columns rather than in rows which happens in traditional tables. For example,

Table:(Current)

Country       Code           Sales

America       USA            2000

Australia       Aus             2500

Germany      Gmy            3000

Should be displayed as

Table:(Expected)

Country        America           Australia             Germany

Code            USA                Aus                    Gmy

Sales            2000                2500                   3000

and this has to be done only in the script not in visualization. I've tried crosstable, transpose function but nothing helped me completely.

[Anonymous]

Then again, are you getting the field names displayed over there and in the resultant table?

[Anonymous]

Here are the screenshots of the enable transformation step and the resultant table. As you can see no field names displayed.

[Anonymous]

Hi All,

  I've tried storing the qvd into the csv format based on the suggestions posted in the community and used the csv file to transpose the data and it seems to be working fine. Thank you all for the help.