Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Table1:
Load * inline [
ID, Type
100, Regular
101, Special
102, SS-C
103, SS-ABC
104, SS-Max
105, SS-C2];
I want to return only
Type= Regular, Special and SS-C*
SS-C* Means starting with SS-C
OutPut Table:
ID, Type
100, Regular
101, Special
102, SS-C
105, SS-C2
Hope you understand...
before ; write:
where Type ='Regular' or Left(Type ,2)='SS'
let me know
this is ok but i want
SS-C and SS-C2 i want to merge into one
SS-C
SS-C2 into one like SS
Like This
Type ='Regular' or Type='Special' or Wildmatch(Type, 'SS-C*'), 'SS')
but it's not working in where condition..
Did i mistake here???
Hi,
In script
load * from TableName where Wildmatch(Type,'Regular','Special','SS-C*');
In front end
USe Calculated Dimension,
if(wildmatch(Type,'SS-C*'),'SS',Type)
Regards
Table1:
Load
ID,
Type,
If(WildMatch(Type, 'SS-C*'), 'SS', Type) AS NewType
FROM DataSource
WHERE WildMatch(Type, 'Special', 'Regular', 'SS-C');
Hope this helps you.
Regards,
Jagan.
Hi,
Try This
Type ='Regular' or
Replace(Wildmatch(Type, 'SS-C*'), 'SS')
Please find the attached
use of pick and wildmatch we can achieve that.