Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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;
That worked
Thanks
-Dushyant