topic Re: pulling data from multiple column in Integration, Extension & APIs

pulling data from multiple column

Anonymous — Sun, 14 Jan 2018 08:39:53 GMT

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

Re: pulling data from multiple column

marcus_sommer — Sun, 14 Jan 2018 10:27:36 GMT

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

- Marcus

Re: pulling data from multiple column

Anonymous — Sun, 14 Jan 2018 11:13:08 GMT

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

Re: pulling data from multiple column

marcus_sommer — Sun, 14 Jan 2018 13:32:56 GMT

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

Re: pulling data from multiple column

Anonymous — Sun, 14 Jan 2018 14:20:17 GMT

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