topic Re: resident table does not appear in data model in QlikView

resident table does not appear in data model

felcar2013 — Thu, 28 Mar 2013 10:44:53 GMT

I want to get a simpliefied timestamp table and order it by %member__timestamp__ID asc. Order by does not work with the qvd and i do not know where to use "order by" in the joined table. So, i decided to first join my tables, then create a resident one and order it. The join worked fine and i got what i want, however i cannot see the resident table. Do you have any idea what is wrong? thanks

timestamp1:

LOAD      "member_PeriodID" as "%member__timestamp__ID",
                Period as "member_timestamp";
SQL SELECT *
FROM "db_A".transfer."vDIM_Period"
where PeriodYear>2008 and PeriodYear<2014 order by Period asc;

inner join (timestamp1)
LOAD Distinct     "KUNDE_Datenstand" as member_timestamp_date,
                            "%member__timestamp__ID"
FROM $(Include=datenquelle\hb_qvd_path.txt)timestamp.qvd(qvd);

timestamp:
load     "%member__timestamp__ID",
            "member_timestamp_date",
            "member_timestamp"
Resident timestamp1;

drop Table timestamp1;

Re: resident table does not appear in data model

alexandros17 — Thu, 28 Mar 2013 10:49:37 GMT

You have to use noconcatenate otherwise the table timestamp and timestamp1 concatenates and you drop them toghether ...

timestamp:

NOCONCATENATE

load     "%member__timestamp__ID",
            "member_timestamp_date",
            "member_timestamp"
Resident timestamp1;

Re: resident table does not appear in data model

pljsoftware — Thu, 28 Mar 2013 10:54:25 GMT

Hi Felcar,

what is for you the resident table?

If it is timestamp1 you drop it on the last row.

If you don't see your timestamp table is because the filds on table are the same name in tables timestamp1 and timestamp. Try to rename the field in timestamp1 as field_TMP and after load it in timestamp with keyword AS.

eg.

timestamp1:

LOAD      "member_PeriodID" as "%member__timestamp__ID_TMP",
                Period as "member_timestamp_TMP";
SQL SELECT *
FROM "db_A".transfer."vDIM_Period"
where PeriodYear>2008 and PeriodYear<2014 order by Period asc;

inner join (timestamp1)
LOAD Distinct     "KUNDE_Datenstand" as member_timestamp_date_TMP,
                            %member__timestamp__ID as "%member__timestamp__ID_TMP"
FROM $(Include=datenquelle\hb_qvd_path.txt)timestamp.qvd(qvd);

timestamp:
load

"%member__timestamp__ID_TMP" as "%member__timestamp__ID",
member_timestamp_date_TMP as "member_timestamp_date",
member_timestamp_TMP as "member_timestamp"
Resident timestamp1;

drop Table timestamp1;

Regards

Luca Jonathan Panetta

PLJ Software

Re: resident table does not appear in data model

felcar2013 — Thu, 28 Mar 2013 11:43:46 GMT

thanks

it was easy

felipe

Re: resident table does not appear in data model

felcar2013 — Thu, 28 Mar 2013 11:44:27 GMT

thanks for this, it seems with only noconcatenate was sufficient, but will try this one too