pulling data from multiple column

[Anonymous]

col1  col2 col3 col4

4        x      y       z

6        z     x       y

8        l     l        m

i wanted to create bar chart and wanted to use one column using filter on x,y,z,l values from 3 columns can i able to do that

thanks

[marcus_sommer]

I think you will need to transform your crosstable into a "normal" table. See here what is meant: The Crosstable Load.

- Marcus

[Anonymous]

thats true but i have 100 coulmns and wants to change only  above 3 columns from it and not alll

[marcus_sommer]

You could just transform these 3 columns within an extra table and keeping the other like they is but I think it's a rather uncommon approach. I believe I would transform the whole table ...

- Marcus

[Anonymous]

yes.that is only option i can see now..seprate table