Hi All,
Below is the Code I Have used..
However I am unable to load the data, while loading the data im getting an error like "Unknown Error"
Kindly help in this.
temp_Budget_table:
LOAD `subject_access_track_id`,
`subject_id` as B_subject_id,
`subject_name`,
`lender_offer_id`,
`subject_status` as B_subject_status,
date(`subject_start_date`,'YYYY-MM-DD hh:mm:ss')as Budget_Start_date,
date(`subject_completed_date`,'YYYY-MM-DD hh:mm:ss')as B_Completed_date,
`total_time_taken`;
SQL SELECT `subject_access_track_id`,
`subject_id`,
`subject_name`,
`lender_offer_id`,
`subject_status`,
`subject_start_date`,
`subject_completed_date`,
`total_time_taken`
FROM SUBJECTACCESSTRACKING ;
left join(temp_Budget_table)
LOAD distinct interactivity_data_type_id, name;
SQL SELECT name,
interactivity_data_type_id
FROM INTERACTIVITYDATATYPES where subject_id=2 and interactivity_data_type_id in(11,12,13,14,15
,16
,17
,18
,19
,20
,21
,22
,23
,24
,25
,26
,27
,28
,29
,30
,31
,32
,33
,34
,35
,36
,37
,38
,39
,40
,41
,42
,43
);
left join(temp_Budget_table)
LOAD `subject_access_track_id`,
`interactivity_data_type_id`,
value;
SQL SELECT `subject_access_track_id`,
`interactivity_data_type_id`,
value
FROM INTERACTIVITY_DATA;
NoConcatenate
ArrangeDataTmp:
LOAD
lender_offer_id, interactivity_data_type_id,name, value
Resident temp_Budget_table;
NoConcatenate
ArrangeData:
LOAD
lender_offer_id,
value as [Selected Expenses]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 11;
Join
LOAD
lender_offer_id,
value as [Identifying Types of Expenses - # Incorrect]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 12;
Join
LOAD
lender_offer_id,
value as [Identifying Types of Expenses - Incorrect Answers]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 13;
Join
LOAD
lender_offer_id,
value as [Adjusting a Budget - Expenses Adjusted []
Resident ArrangeDataTmp
Where interactivity_data_type_id = 14;
Join
LOAD
lender_offer_id,
value as [Adjusting a Budget - Amount Adjusted]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 15;
Join
LOAD
lender_offer_id,
value as [Budgeting - total income]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 16;
Join
LOAD
lender_offer_id,
value as [Credit Card Payments]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 17;
Join
LOAD
lender_offer_id,
value as [Loan Payments]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 18;
Join
LOAD
lender_offer_id,
value as [Groceries]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 19;
Join
LOAD
lender_offer_id,
value as [Toiletries]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 20;
Join
LOAD
lender_offer_id,
value as [Eating Out]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 21;
Join
LOAD
lender_offer_id,
value as [Rent/Mortgage Payment]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 22;
Join
LOAD
lender_offer_id,
value as [Electricity/Gas]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 23;
Join
LOAD
lender_offer_id,
value as [Cable/ISP]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 24;
Join
LOAD
lender_offer_id,
value as [Cell Phone]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 25;
Join
LOAD
lender_offer_id,
value as [Medical Expenses]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 26;
Join
LOAD
lender_offer_id,
value as [Entertainment]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 27;
Join
LOAD
lender_offer_id,
value as [Transportation]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 28;
Join
LOAD
lender_offer_id,
value as [Insurance]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 29;
Join
LOAD
lender_offer_id,
value as [Other]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 30;
Join
LOAD
lender_offer_id,
value as [Savings]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 31;
Join
LOAD
lender_offer_id,
value as [Combines Monthly Expenses]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 32;
Join
LOAD
lender_offer_id,
value as [Mobile - Budgeting - total income]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 33;
Join
LOAD
lender_offer_id,
value as [Mobile - Housing]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 34;
Join
LOAD
lender_offer_id,
value as [Mobile - Food]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 35;
Join
LOAD
lender_offer_id,
value as [Mobile - Transportation]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 36;
Join
LOAD
lender_offer_id,
value as [Mobile - Cell Phone]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 37;
Join
LOAD
lender_offer_id,
value as [Mobile - Loans and Cards]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 38;
Join
LOAD
lender_offer_id,
value as [Mobile - Medical Expenses]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 39;
Join
LOAD
lender_offer_id,
value as [Mobile - Personal]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 40;
Join
LOAD
lender_offer_id,
value as [Mobile - Insurance]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 41;
Join
LOAD
lender_offer_id,
value as [Mobile - Savings]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 42;
Join
LOAD
lender_offer_id,
value as [Mobile - Combined Monthly Expenses]
Resident ArrangeDataTmp
Where interactivity_data_type_id = 43;
DROP Table ArrangeDataTmp;
