Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Here it is
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;
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