Good morning everyone! First of all I apologize because this text was translated by Google Translator and may contain translation errors. I am looking for information on a method called BalanceLine but I do not find any reference on the subject so I bring it to you. The general concept of BalanceLine is to read records of two ordered tables that have some logic resulting in a match process that resembles "Merge" but without it being possible for a record to match with more than one record from the other table. Exemplifying D1 FIELD A A B C C E E F D2 FIELD A B C C D E F G Applying a Merge the result would be: D3 FIELD A A B C C C C E E F However applying "BalanceLine" would return: D3 FIELD A B C C E E F The logic of "BalanceLine" follows: D1 FIELD A A B C C E E F D2 FIELD A B C C D E F G The Balance line checks the registration tables to regiastro, assuming that the tables are ordered according to the need.
When it finds situation that satisfies the condition between the tables it advances a record in both.
If in the new comparison the registers are not the same the programming will advance the record of lower value. When "OK" add register in "D3"
D1 D2 A x A - OK (Add Register in D3, Move next D1 and D2)
A x B - NOK Move next D1 B X B - OK (Add Register in D3, Move next D1 and D2)
C X C - OK (Add Register in D3, Move next D1 and D2) C X C - OK (Add Register in D3, Move next D1 and D2
E X D - Move next D2 E X E - OK (Add Register in D3, Move next D1 and D2) E X F - Move next D1 F x F
In the example used, the balance line will consider records that have the same information in both tables. Is there any Proc that does this type of treatment? Attachament: Balanceline VBA CODE example. Muito Obrigado!
... View more