Creating a line chart without using continuous

[markgraham123]

Hi,

I'm struck at a point where i have to display the data using Line chart.

Since i have thousands of records on X-axis, i have to use Continuous to show the trend at a time.

But when i use "Continuous" i'm not getting the order i need.

Can someone look in to the attached application and lemme know how can i load in the same order which is specified in the table of the application.

I'm trying to get o/p like the attached image.

[markgraham123]

SKU on x-axis and other dimension on Y-axis.

[MarcoWedel]

Hi,

one solution could be:

table1:
LOAD Dual(SKU#,RecNo()) as SKU#,
    [30-day Relative Velocity %]
FROM  (txt, utf8, embedded labels, delimiter is '\t', msq, no eof);

hope this helps

regards

Marco