HI, folks i have been struggleing with this and need some help. I have some data in a QV Document that is in what i call a vertical format now like example below
I want to convert it so that when i view in QV table object as this way
I think i should be able to do it with Set analysis... I don't want to do it with the load script because i also need to be able to do a search on all owners with a particular model of car in a particular zipcode... etc. but when i display the results of a serch in a report format i want to see all the customers cars on one line.
If you don't have to split them into separate fields (which I think you have to use the load script for then you could use Concat(). So in your straight table chart above your dimensions would be Customer Number, Name, Gender and Zipcode, and your expression would be:
Yes i only want to view them as though they were seperate fields. I am trying to keep from creating the same data twice. So i have it all in one field so that i can do a search for any customer with a particular car but when i diplay that customer i want to see all the cars they may have on the same line.
there is another solution to your problem...you can use the concept of transpose in the pivot table...i am attaching the snap shot of the document which i have developed if it works for you tell me i will provide you the whole solution.