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

[parthakk]

Hi,

Where is amount field in your datamodel? I mean which table holds this field?

[#3]

pay_amount is the amount field.

Its in Payment_Temp table under receivables tab in the script

[Anonymous]

Keerthi,

I think you forget to load you mapping tables as mapping load .

Check your mapping table :

You need to load these tables as mapping table

Like you have done for

MapBlock_CBPID:

Mapping

LOAD Distinct P_ID,B_ID Resident Projects where Len(Trim(CPB_ID))<>0;

/***************************************************************

here is the problem -

Map_State_Payment:

LOAD 

uniqueid,

state

FROM

[$(vPath)\tesaleorde.qvd]

(qvd);

Map_Stage_Payment:

LOAD 

uniqueid,

stage

FROM

[$(vPath)\tesaleorde.qvd]

(qvd);

Map_Status_Payment:

LOAD 

uniqueid,

status

FROM

[$(vPath)\tesaleorde.qvd]

(qvd);

Map_State_Payment:

LOAD 

uniqueid,

state

FROM

[$(vPath)\tesaleorde.qvd]

(qvd);

Map_Stage_Payment:

LOAD 

uniqueid,

stage

FROM

[$(vPath)\tesaleorde.qvd]

(qvd);

Map_Status_Payment:

LOAD 

uniqueid,

status

FROM

[$(vPath)\tesaleorde.qvd]

(qvd);

[parthakk]

Hi Keerti,

If i am not wrong u are expecting mapping between status(S_status), stage(S_stage) and state(S_state) with amount(pay_amount), right? U have dropped table Payment_Temp and before dropping u have not saved pay_amount field in any other table.. So how can there be any mapping.

Thanks,

Partha Kulkarni

[#6]

Yes you are right.

Where should i drop the table ?

Regards,

Keerthi KS

[#7]

I did mapping. But without applymap also there should be mapping right ?

[parthakk]

Hi,

First need to know the reason for table dropping. And if u want it to drop then u must have pay_amount field somewhere in other tables.. If u drop table then its like deleting that field hence no mapping at all.

Thanks,

Partha Kulkarni

[#9]

But there is a field(Pay_amount) even after dropping the table Payment_Temp.

Concatenate(Projects)

LOAD *,if(Len(Trim(S_ID))<>0,Enq_ID_Temp,ApplyMap('MapOppEnqID',Map_Opp_ID)) as Enq_ID,Receivable_Date as Unit_Link Resident Payment_Temp;

Here we are concatenating with Projects and then dropping it. so Mapping should be there.

This is developed by someone else and currently i am working on it.

[Anonymous]

actually your mapping is with uniqueid column not with Stage.

So when you will select SID or uniqueid you will get the amount but for Stage you will not as in concatenate you are not making the column name same for Stage.

Thanks

BKC