topic Re: issues loading data from my temp table (information loaded from Excel) into the Facts table in QlikView

issues loading data from my temp table (information loaded from Excel) into the Facts table

Anonymous — Tue, 22 Sep 2015 05:54:01 GMT

Hi,

I thought my problem was resolved but i am still having issues loading data from my temp table (information loaded from Excel) into the Facts table. The information loads into the temp table correctly:-

The fact table is blank.

What can i check?

Any help/suggestions appreciated.

Cheers

Re: issues loading data from my temp table (information loaded from Excel) into the Facts table

tresB — Tue, 22 Sep 2015 06:00:14 GMT

Check the #Tip5 here: Qlik Community Tip: Posting Successful Discussion Threads (sorry that's not the answer)

Re: issues loading data from my temp table (information loaded from Excel) into the Facts table

jonathandienst — Tue, 22 Sep 2015 06:01:57 GMT

You need to provide a lot more information - its hard to debug a script if you don't know what's in it.

Re: issues loading data from my temp table (information loaded from Excel) into the Facts table

Anonymous — Tue, 22 Sep 2015 06:06:07 GMT

attached is the script i am using

Re: issues loading data from my temp table (information loaded from Excel) into the Facts table

tresB — Tue, 22 Sep 2015 06:14:38 GMT

Is this your complete script? Hope not. There has to be a table called 'Facts' that has been loaded before this code section, right?

Re: issues loading data from my temp table (information loaded from Excel) into the Facts table

jonathandienst — Tue, 22 Sep 2015 06:26:01 GMT

I assume that's not the full script - you are concatenating to Facts, but when is Facts loaded?

Your date logic in the concatenation is a bit contorted and may be problematic, rather use the date functions than string mangling

Date(MonthStart(TargetDate), 'YYYYMM') As %DateKey,

Re: issues loading data from my temp table (information loaded from Excel) into the Facts table

PrashantSangle — Tue, 22 Sep 2015 06:32:03 GMT

Hi,

When you do crosstable concept with date field then your date field is converted into text format.

therefore if you want to change its format then use

Date(num#(fieldName,'YourDateFormat')

by using above syntax you can avoid MakeDate() and Num() from your script

try

Date(num#(TargetDate),'YYYY/MM/DD') as %DateKey

instead of

MakeDate(num(right(TargetDate,4)),num(mid(TargetDate,3,2)),1) as %DateKey,

also provide us what kind of data is available in fact table.

Regards