How to do this

[ecabanas]

I have a table with the product cost(A) and another table with the cost from invoices(B).

I would like to find from the A table the item cost and find the last invoice cost from B table

Anyone knows how to do this?

Many thank's

Eduard

[#2]

Hi,

Could you please elaborate your requirement.

[Anonymous]

Hi ,

So what I understand you want to get the invoice from Table B,  with same cost in Table A (Latest Date)

Then the last Cost 175 should attach with 1111 invoice no. correct ??

or you are considering any other logic ??

Thanks

BKC

[#4]

Hi,

By reading your query what I can understand is you have to map invoice of table B to Table 1having the same cost & same ItemID.Just applymap it if that the issue.But i guess the requirement is something else.

[ecabanas]

Hi Balkumar,

I just added the example. I would like to add a for every fiel from A table the lattest invoice cost for each row.

Many thank's

[Joaquin_Lazaro]

Hi Eduard:

RealCost:

Load ....

       Trim(ItemID) & '+' & Cost as KeyRC

InoviceCost:

Left join (RealCost)

Load ....

       Trim(ItemID) & '+' & Cost as KeyIC

You should manage the field names in order to avoid syntetic keys !!!

Hope this helps you.

Joaquín

[Joaquin_Lazaro]

Hi Eduard:

Look at the attached app.

But .... If the real cost fo AA 01/03/2015 is 1.75 the invoice is 1111

Regards

Joaquín

[ecabanas]

Hi Joaquin,

I attached your answer, but did not solve the problem.

For example the second line in cost table is linked with invoice line "11111" and has to be linked to invoice "4444"

Many thank's for your patience

Eduard

[Joaquin_Lazaro · Accepted solution]

Hi Eduard:

No arrow for the 4444 invoice !!!!

The second line in the real cost line has an arrow to the 3333 invoice.

Do I miss anything ?

Joaquín

[ecabanas]

SOrry Joaquin, you are right, my falt!!

MAAANY thank's for your help

Regards

Eduard