Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Could you please elaborate your requirement.
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
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.
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
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
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
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
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
SOrry Joaquin, you are right, my falt!!
MAAANY thank's for your help
Regards
Eduard