convert row in to column !!!

[#1]

Hi All,

          I have a Qvd which contains some fields like:

         Response _id,

          Date,

        category ,

        Qid,

        Response

      i want to convert Response row data into column ,i tried with generic load getting ans but data model should not be correct by using generic

this my original data:

Response _id	Qid	Response
1001	100	3
1001	101	5
1001	102	8
1001	103	6

and i want convert  into

Response _id	101	101	102	103
1001	3	5	8	6
1002	2	7	8	9

   For More clarification see my attachment 

  can any one help me

please find attachment

[senpradip007]

PFA

[Peter_Cammaert]

What is wrong with the data model after the GENERIC LOAD?

If you have too many tables, check Henric's post for a trick to

JOIN them together: http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic

Best, Peter

[#4]

Hooooo god i tried with the generic load am getting correct ans  but when u comes to the data model every field is converted into table

that means

101 field convert in to table

102 field convert in to table

.

.

.

.

soooo on

i dont want use generic load may i get any solutuion

[Peter_Cammaert]

BTW It's not always "wrong" to get a lot of tables, just like it isn't always "wrong" to have synthetic keys. It just looks ugly in the table viewer...

[#6]

Hi,

Option I can suggest is to load the data in QVW and change the presentation as you would like to see.

PFA

[#7]

can u attach sample Qvw with respective of that ans plss

[anbu1984 · Accepted solution]

Try this

[senpradip007]

PFA

[#10]

thank u but how u can got Horizontal bar in pivot table i did't found in presentation tab also

am getting vertical pivot table  so

can u help me pls