topic Re: working with wildmatch result in QlikView

working with wildmatch result

bumin — Mon, 05 Jan 2015 10:30:52 GMT

I have the following problem. I don't know if there is a solution for it.

Customer table

Customer:

JOHN

BILL

MICHEAL

I have a field which contents the customer names

PTEXT

Payment from JOHN 5 EUR

Cheque BILL 10 $

...

I want to read the field PTEXT and apply it to my customer table to be able to recognize which Text is from which customer

thanks

Bumin

Re: working with wildmatch result

alexandros17 — Mon, 05 Jan 2015 10:42:23 GMT

Here it is

Re: working with wildmatch result

anbu1984 — Mon, 05 Jan 2015 10:44:12 GMT

Customer:

Load *,1 As Key Inline [

Customer

JOHN

BILL

MICHEAL ];

Left Join(Customer)

PTEXT:

LOAD *,1 as Key Inline [

Txt

Payment from JOHN 5 EUR

Cheque BILL 10 $ ];

NoConcatenate

Final:

Load Distinct Customer Resident Customer;

Left Join(Final)

Load Txt,Customer Resident Customer where Index(Txt,Customer);

drop table Customer;

Re: working with wildmatch result

rubenmarin — Mon, 05 Jan 2015 10:53:49 GMT

Hi Burmin,

See attached, you can start with this, probably you must add some functionality to avoid duplicated rows if more than one customer name is found in any PText