loading Problem

[#1]

Plz see below attached file  i have faced loading problem it will not load the data. it was struck.

Thanks

Joshna

[#2]

what ever we use concatenation or join it merge the tables Sasidhar that is an issue

here the problem is load is struck it can't show the error .

one question

What purpose we this type script

DepartmentID & '_'  & Date as ExpenseKey

[#3]

what ever we use concatenation or join it merge the tables Sasidhar that is not  an issue

here the problem is  it can't show the error .

one question

What purpose we this type script

DepartmentID & '_'  & Date as ExpenseKey

loading Problem

[Digvijay_Singh]

In QV it is recommended to have one key field for association between tables, whenever we are in situation of having two key fields (Date and Department ID in your case), we try to form a composite key. The problem in your case it seems expense category also is common between department and budget. Expenses you are already merging to department.

[sasiparupudi1 · Accepted solution]

Try chaning your script

Expenses:

Load

     DepartmentID & '_' & Date as ExpenseKey

      Amount,

     Billable,

Date,

[Expense Type],

DepartmentID,

Employee

from your qvd;

(qvd)

left join(Expenses)

Load [Expense Category],[Expense Type]

from your excel file;

remove the last join distinct

DepartmentID & '_'  & Date as ExpenseKey

basically joining the two fields with a _ in betwwen ex: 1_2015/02/01

hth

Sasi

[#6]

Its done sasidhar but it create synthetic key in data model