Could you help me do Wildmatch with the value of a column?

[Anonymous]

I was have a table

SQL SELECT Track,

                    Proc_ID,

                    Qty

FROM "SQL_A".dbo."Data_Track";

I would like to locate all that has '*_TM_*' whether it is a lowercase or an uppecase

I will be creating another column for the result which is the showme field

I have this script

If(WildMatch([Proc_ID],'*_TM_*'), (Qty+7)*2, If(WildMatch([Proc_ID],'*_0*'), (Qty+7)*5, 'Nothing Found')) as showme

Upon Running I had this error

ErrorMsg: 'WildMatch' is not a recognized built-in function name

Please help, I'm confused. Thanks.

[jmvilaplanap]

Hi,

Try this: wildmatch function

[vishsaggi · Accepted solution]

Try this? Correct me you were using this wildmatch in SQL Script, if so, Wildmatch is a QV native function and does not work in SQL Script i believe. Try below:

Table:

LOAD Track,

           Proc_ID,

           Qty,

           If(WildMatch([Proc_ID],'*_TM_*'), (Qty+7)*2, If(WildMatch([Proc_ID],'*_0*'), (Qty+7)*5, 'Nothing Found')) as ShowMe;

SQL SELECT Track,

                    Proc_ID,

                    Qty

FROM "SQL_A".dbo."Data_Track";

[antoniotiman]

Hi Cherry,

WildMatch is QV Function (not SQL).

Use Preceding Load.

Regards,

Antonio

[Anil_Babu_Samineni]

You condition should work, But thing is you doing this in SQL engine. So it  won't work. Try to use only in LOAD statement rather SELECT statement.

[qv_testing]

Yes, they are correct.

otherwise take resident load as a main table and apply your condition.

That should work.

[Anonymous]

Hi,

Its working fine now after I used LOAD. Thanks for your help. It is much appreciated.

Regards,

Cherry