Data Model Issue

[#1]

Hi All,

I have an issue with my model.

I have attached 2 models

1. Test

2. Data Model

In the test i have loaded 2 files where you can see the status, stage and states are  mapping with the amount.

Similarly i have loaded in Data  model (Which is my final model with all the tables) where there is no mapping between status(S_status), stage(S_stage) and state(S_state) with amount(pay_amount)

Please let me know if you need any other information.

Regards,

Keerthi KS

[#2]

But saleorder(SID) is mapped to Stage, state and status. Which inturn has to be mapped with  payamount. These mappings can be seen in test.qvw

Saleorder is mapped to Stage, state and status.

Status stage and state is mapped to payamount

[parthakk]

Hi,

In receivables line no:57 u used resident projects but i found nowhere as projects table earlier..  For doing any concatenate you should have a table with us, am i right?

Thanks,

Partha Kulkarni

[#4]

Projects table is in Projects tab. The second tab. Table exists

[parthakk]

Hi Keerthi,

Earlier your mapping was between stage,status and state and that exists even now.. If u select s_status or so it wont work. For that u need to check your mapping table. You are fetching it from 'Map_State_Payment' but i doubt on that.

I could not find your mapping load at all... Make sure that after u do apply map u get data associated between s_status and UNIQUEID.

Thanks,

Partha Kulkarni

[#6]

S_Status is the alias of status.

Currently mapping is working with pay_amount and s_status. But without mapping it wont work ?? because S_ID is already mapped with pay_amount and S_ID with S_status.