Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

convert row in to column !!!

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 QidResponse
10011003
10011015
10011028
10011036

and i want convert  into

Response _id101101102103
10013586
10022789

   For More clarification see my attachment 

  can any one help me

please find attachment

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

17 Replies
senpradip007
Specialist III
Specialist III

PFA

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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...

Not applicable
Author

Hi,

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

PFA

Not applicable
Author

can u attach sample Qvw with respective of that ans plss

anbu1984
Master III
Master III

Try this

senpradip007
Specialist III
Specialist III

PFA

Not applicable
Author

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