working with wildmatch result

[bumin]

Hi

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

[alexandros17]

Here it is

[anbu1984 · Accepted solution]

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;

[rubenmarin]

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