Need Help

[paulwalker]

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...

[alexandros17]

before ; write:

where Type ='Regular' or Left(Type ,2)='SS'

let me know

[paulwalker]

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???

[PrashantSangle]

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

[jagan]

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.

[#6]

Hi,

Try This

Type ='Regular'  or

Replace(Wildmatch(Type, 'SS-C*'), 'SS') 

[sunilkumarqv]

Please find the attached

use of pick and wildmatch we can achieve that.