Link new table with existing data model

[prma7799]

Hi All,

I have one application based on link table concept I want to add new table called "New Table"

I tried to add this table but I totally struct.

Please refer below post

How to link new excel file to existing data model

Thanks

[sasikanth]

hi,

i think you just need only target field,

Do a left join with Fact_GL_Entry based on Div_code

[sunny_talwar]

I don't see what the issue is? I see the table has been added already? Why do you think you are stuck?

[prma7799]

Hi Sunny ,

My problem is when I am select any MonthName then my target is not coming according to month.

Thanks

[prma7799]

Hi Sunny K,

I tried it but not get expected output.

Thanks

[prma7799]

sunindia‌

Please find the attached... I am got 49625.22 for the month of april.

My expected out is 835.58

Thanks

[sathishkumar_go]

Hi,

I think target table is not linked properly.

How you are linking the Target table in to your existing data modelling?

-Sathish

[prma7799]

Hi Satish,

Thanks for your response.

I am linking via div_code...

Thanks

[sathishkumar_go]

You have to use month or date also to link the target table

-Sathish

[prma7799]

Hi jagan‌ , tresesco‌ , sunindia‌, swuehl‌

I trying with below code  PFA but when i select div_region and region and it will not associated with proper div_code.