Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends:
I have 3 dates in my Parent table.
For a Task, the values coming are
Disv_Date Int_Date LiveDate
01/02/2012 02/02/2012 03/02/2012
but my requirement is to display them as
Disv_date 01/02/2012
Int_Date 02/02/2012
Livedate 03/02/2012
How can i do this.
Using Inline Load, i can make date column like
Load * Inline
[Make_Date
Disv
Int
Live];
This will give me dates/text vertically. I can resident load my main table to get the above 3 dates
but how to a make them such that the format looks like below
Disv_date 01/02/2012
Int_Date 02/02/2012
Livedate 03/02/2012
Thanks in advance for your help.
Try with this
MainTable:
LOAD * Inline [
Disv_Date,Int_Date,LiveDate
01/02/2012,02/02/2012,03/02/2012
];
ResultTable:
LOAD 'Disv_Date' AS Key, Disv_Date AS Value
Resident
MainTable;
LOAD 'Int_Date' AS Key, Int_Date AS Value
Resident
MainTable;
LOAD 'LiveDate' AS Key, LiveDate AS Value
Resident
MainTable;
HI
Try like this
CrossTable(Dimension,Date,1)
lOAD RowNo() as Row, * Inline
[
Disv_Date,Int_Date,LiveDate
01/02/2012,02/02/2012,03/02/2012
];
Try with this
MainTable:
LOAD * Inline [
Disv_Date,Int_Date,LiveDate
01/02/2012,02/02/2012,03/02/2012
];
ResultTable:
LOAD 'Disv_Date' AS Key, Disv_Date AS Value
Resident
MainTable;
LOAD 'Int_Date' AS Key, Int_Date AS Value
Resident
MainTable;
LOAD 'LiveDate' AS Key, LiveDate AS Value
Resident
MainTable;
If your requirement is just to display the three dates vertically, you may create a straight table chart with no dimensions and the following dates as three expresions with 'No Totals' selected.
Disv_Date
Int_Date
LiveDate
An example is attached.
Mayil:
This worked.
Thanks a lot.
Celambarasan:
This also worked.
Thanks you guys so much.
Krishnamoorthy:
Thanks for your response.
This is what i need. I did exactly like you did
except that yours is Inline load and mine is coming from the table but still i don't get the format like yours.