resident table does not appear in data model

[felcar2013]

hi

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;

[alexandros17 · Accepted solution]

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;

[pljsoftware]

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

[felcar2013]

thanks

it was easy

felipe

[felcar2013]

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