Canonical Dates for 1 table

[#1]

Is it possible to create canonical date when all your information is located in 1 table?

I'm trying to create Line charts with 6 different values. I have created Master Calendar which is not so helpful.

Please suggest, if possible to create a canonical date when all your information is located in 1 table.

Thanks in Advance

-Dushyant

[#2]

swuehl‌

I tried with larger data sets. 'I_MASTER_ID' is not unique in data set.

Do you have to have unique column for canonical date to work, even though data is from 1 table?

[swuehl]

to filter only the original records with selected canonical dates, you should link your tables using a primary key of your original table. If you don't have one yet, create a primary key e.g. using Recno() in the table LOAD:

LOAD

     Recno() as PrimaryKey,

    *

FROM MEDDS;

[#4]

That worked

Thanks

-Dushyant