Omission of loop created & to achieve what is expected

[nevilledhamsiri]

Dear Our Experts

Please help me to overcome the issue I am forwarding to you. I have loaded two tables both table carries BR_CODE , PRODUCT_CODE hence when the data are loaded a loop is created. What I did was to rename the BR_CODE as B_CODE then the former issue wont come but what I expect is not getting. As can be seen what is in the NRP Table total sum of both RA & EH get populated in every Branch code. Actually what is in the NRP table carries data for only RA & EH codes. Please go through my working & help me to get my output.

Thanks

Neville

[nevilledhamsiri]

Please let me have the answer on the body of the reply as I work on personnel edition.

Thanks

[nevilledhamsiri]

Appreciate if this is looked in to.

Thanks in advance

[nevilledhamsiri]

Dear Friends

Kindly look in to this if you are free

Neville

[juraj_misina]

I think that you should try concatenating both tables. Thus you would not need to rename BR_CODE and won't get any loops.

[nevilledhamsiri]

Hi, Juraj

There are three tables rather one comes through inline loading. The issue is even if it is concatenated, my required out put wont come. Could you please send me your answer in the body of the reply

Thank you

Neville

[nevilledhamsiri]

Dear Stefan, Viswarath,Dilip Ranjith,Ruben,Frank & all other experts

I  am really down with the issue of achieving my out put as per the case highlighted. Concatenation & all other attempts were failed. Since I need to have a proper application in resolving this issue, I am seeking my dear all to help me on this.

Thank in advance

Neville

[dplr-rn]

Nevile

the issue is the different levels of granularity between the tables.

your inline  is PRODUCT_CODE, ACCOUNT_CODE

NRP BR_CODE , PRODUCT_CODE

while the FR  table is BR_CODE, ACCOUNT_CODE

your visualization wants BR_CODE , PRODUCT_CODE

it doesn associate it self neatly within it self

i think you will need to use a generik key concept and link all of these dimensions together

check below

Generic keys

[nevilledhamsiri]

Dear Ranjith,

Thanks a lot for helping me out on this. Frankly speaking I have no much idea what you propose being done over my data set. If you don't mind could you check my data & provide me some working. I have no idea where & how to start this altogether. I have actually three tables & their dimensions

TB-Table: (ACCOUNT_CODE,BR_CODE,TYPE)

NRP-Table:  (BR_CODE,PRODUCT_CODE)

IN LINE-Table (ACCOUNT_CODE,PRODUCT_CODE)

I have got some difficult calculations using In line data. If possible, while keeping that data as it is, are we having some alternatives to do on balance two tables. Sorry for troubles made, if possible please provide me some working with the places where such treatments to be made

Thanks a lot for your time to response me

Neville

[dplr-rn]

Not sure how i can help it is partly technical partly business question.

e.g. the question for you is how is 1 row in NRP BR_CODE,PRODUCT_CODE combination linked to which rows in TB ACCOUNT_CODE,BR_CODE

depending on that you create a link table (generic keys) for those combinations.