MATCH FIELDS

[upaliwije]

I have following data fields in a table

Customer          Payee            AMOUNT         

A                    TOYATO              10000

B                    M/S TOYOTA         7500

C                   Toyota pvt ltd          4000

D                    DIMO                    2000

E                     DIMO COMPANY  15000

F                          Dimo                    100

I want to  sum  amount according to payee name. Since the payee name . Since the payee name recorded differently pls help with a expression to extract data

[sujeetsingh]

You can use subfield function to do this but before you need to come up with the consistency in the names .

[#3]

Hi,

How your Output Should look like ? Can u upload sample output Table ?

[PrashantSangle · Accepted solution]

Hi,

Use combination of wildmatch() and Special charater *

Like

If(wildmatch(Payee,'*Toyato*'),sum(Amount))

Regards

[#5]

please elaborate your requirement,post the output table which you want.

[ashfaq_haseeb]

Hi,

Have a look at the attached application.

Regards

ASHFAQ

[jagan]

Hi,

Try to create one more with Customer and Payee names like below.

Data:

load * Inline

[

Customer,Payee,AMOUNT        

A,TOYATO,10000

B ,M/S TOYOTA,7500

C ,Toyota pvt ltd,000

D ,DIMO,2000

E,DIMO COMPANY,15000

F,Dimo,100

];

LEFT JOIN(Data)

load * Inline

[

Customer,PayeeCategory  

Toyota,A

Toyota ,B

Toyota ,C

Dimo ,D

Dimo,E

Dimo,F

];

Now PayeeCategory as Dimension in your chart.

Create an excel and maintain the Customer mapping details so that it would be easier to maintain.

Regards,

Jagan.