Filter data based on Pattern Match

[#1]

Hi All,

I have a load script where data has to be filtered based on [WBS Element].

I need data only starting with some [WBS Element] like

0043-,0053- , 0060-

Please help me in filtering data of this pattern.

Attached the Qvw.

Thanks,

Keerthi KS

[jagan · Accepted solution]

Hi,

Try like this

LOAD

*

FROM DataSource

WHERE WildMatch([WBS Element], '0043-*','0053-*' , '0060-*');

Hope this helps you.

Regards,

jagan.

[tresesco]

May eb like:

Load    

          *

From <>  where Wildmatch([WBS Element], '0043-*','0053-*' , '0060-*');

[arulsettu]

try this

=if(WildMatch([WBS Element],'0043-*','0053-*' , '0060-*'),[WBS Element])

[#5]

Thanks a lot Jagan