Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on this.
In the below date field I am getting 5,6 from the excel source file load.
Please help me on deleting 5,6 from the filter pane in the front end. I cant delete in the backend.
Thanks in advance.
1) In Script
TabDate:
Load * inline [
Date,
2012-01,
2012-02,
2012-03,
2012-04,
2013-01,
2013-02,
2013-03,
2013-04,
5,
6
];
TabDate2:
NoConcatenate
Load
Date
Resident TabDate where Not IsNum(Date);
Drop Table TabDate;
2) In frontend:
=If(Not IsNum(Date),Date) as Calculated Dimension in Filterpane
You can filter out the values that should be shown in the filter pane by using an expression.
=If( Date >= MakeDate(2015,1,1) , Date )
1) In Script
TabDate:
Load * inline [
Date,
2012-01,
2012-02,
2012-03,
2012-04,
2013-01,
2013-02,
2013-03,
2013-04,
5,
6
];
TabDate2:
NoConcatenate
Load
Date
Resident TabDate where Not IsNum(Date);
Drop Table TabDate;
2) In frontend:
=If(Not IsNum(Date),Date) as Calculated Dimension in Filterpane