Compare two files

[spividori]

Hi.

I have this model and I need to compare the amounts of object 1 vs Rubro2 when they are equal.

This is a small example of my model, I could establish a link between Vend and heading, but in my original model more complex and need to do it this way.

Regards.

[alexandros17]

Ecco il miol esempio, guarda "MY TABLE"

[its_anandrjs]

Is there any problem if you take this table in single table like with join of left join for comparing the fields.

[jonathandienst]

Hi

When I need to do this type of comparison, I concatenate the sets into a single fact table with a source field to indicate the original data source. It is then very easy to compare. So the load would be like:

Data:

LOAD *,

     'Tbl1' As Source

FROM Tbl1;

Concatenate

LOAD *,

     'Tbl2' As Source

FROM Tbl2;

Then to compare, create a straight or pivot table with Vend as the dimension and for the expressions (to compare field Rubro):

     Tbl1    =Sum({<Source = {'Tbl1'}>} Rubro)

     Tbl2    =Sum({<Source = {'Tbl2'}>} Rubro)

     Diff      =Column(1) - Column(2)

HTH

Jonathan

[spividori]

Thanks for responding, but would not it be done with Set Analysis directly?

Regards.