topic Re: loading Problem in QlikView

loading Problem

Tue, 25 Aug 2015 07:55:10 GMT

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

Thanks

Joshna

Re: loading Problem

Ralf-Narfeldt — Tue, 25 Aug 2015 07:57:27 GMT

What happens, which error message do you get?

Re: loading Problem

Chanty4u — Tue, 25 Aug 2015 08:05:34 GMT

after loading only u wrote the script ryt....?can u chk the qvd path..or else reload ..which error ur gettng can u paste here.

thank you

Suresh

Re: Upload Problem

Chanty4u — Tue, 25 Aug 2015 08:06:44 GMT

did u chked the databse connection string.

Re: loading Problem

sujeetsingh — Tue, 25 Aug 2015 08:59:20 GMT

If possible just provide some log file or meg of error.

Re: loading Problem

sasiparupudi1 — Tue, 25 Aug 2015 09:06:07 GMT

plese try if it load data if you remove the last left join load distinct?

hth

Sasi

Re: loading Problem

Digvijay_Singh — Tue, 25 Aug 2015 09:13:25 GMT

Expense Category in Budget and expenses could be a problem, do you want association between budget and expenses based on expense category. Surely the actual error statement will help to know the real cause else we will be guessing.

Re: loading Problem

Tue, 25 Aug 2015 09:20:07 GMT

That is mandatory

Re: loading Problem

sasiparupudi1 — Tue, 25 Aug 2015 09:22:10 GMT

yeah but your problem is in there I believe.. you got to find another way to do it

Re: loading Problem

sasiparupudi1 — Tue, 25 Aug 2015 09:23:11 GMT

may be use concatenate instead of join

Re: loading Problem

Tue, 25 Aug 2015 09:29:11 GMT

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

Re: loading Problem

Tue, 25 Aug 2015 09:31:13 GMT

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

Re: loading Problem

Digvijay_Singh — Tue, 25 Aug 2015 09:34:07 GMT

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.

Re: loading Problem

sasiparupudi1 — Tue, 25 Aug 2015 09:35:37 GMT

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

Re: loading Problem

Tue, 25 Aug 2015 09:40:35 GMT

Its done sasidhar but it create synthetic key in data model