LOAD specific cell according to its value from excel

[#1]

Hi

I have a column in excel sheet that contains random values from the set {A, B, C, D, E}.
I want to plot each value (A, B, ...,etc.) as a single line in line chart. How can I do that using script?

[awhitfield]

Hi Adnan,

could you expand your requirement please? Maybe supply an example data source file and a mock up of you expected output?

Thanks

Andy

[#3]

Hey Andrew

In the attached photo you can find two columns; one for quality grade and the other is for the year.
I want to plot each quality grade (a, b, c ...) as a single line in line chart progressing over time.
In this case I would get one line chart; dimension is "Date" and measure is "Test Quality" with a line for each grade (a, b, c ...).

[reddy-s]

Hi Adnan,

Yes its possible.

In this case you need to do something similar to this:

Check this out:

Thanks,

Sangram Reddy

[reddy-s]

Sample File!

[#6]

Thanks Sangram

But, according to my attached photo, what I actually want is plotting each quality grade in a single line in the chart. That is: a line for grade 'a', a line for 'b', a line for 'c', ...., etc.

PIC.jpg

[undergrinder]

Hi Adnan,

Try this:

Table:

Load

     if(Test_quality='a',measure,0) as a

    ,if(Test_quality='b',measure,0) as b

    ,if(Test_quality='c',measure,0) as c

From [YourFile];

G.