Solved: Re: loading Problem - Qlik Community

Report Inappropriate Content · ‎2015-08-25

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

Thanks

Joshna

sasiparupudi1 · ‎2015-08-25

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

View solution in original post

Ralf-Narfeldt · ‎2015-08-25

What happens, which error message do you get?

Chanty4u · ‎2015-08-25

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

Chanty4u · ‎2015-08-25

did u chked the databse connection string.

sujeetsingh · ‎2015-08-25

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

sasiparupudi1 · ‎2015-08-25

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

hth

Sasi

Digvijay_Singh · ‎2015-08-25

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.

Report Inappropriate Content · ‎2015-08-25

That is mandatory

sasiparupudi1 · ‎2015-08-25

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

sasiparupudi1 · ‎2015-08-25

may be use concatenate instead of join