topic NoConcatenate Assistance - two table same information in QlikView

NoConcatenate Assistance - two table same information

Mon, 29 Dec 2014 16:08:59 GMT

T_BDE_DAILY:

LOAD

[LOAN NUMBER],

[LOAN SETUP DATE],

FROM $(qvd_layer_2_path)T_BDE_DAILY.qvd(qvd)
where [Loss Mit Status Code] = 'A' and [Servicing Sold ID] <> 'NSM120110' and [Referral Code] <> 'CARC' ;

FINAL_TABLE:

LOAD DISTINCT

[LOAN NUMBER],

[LOAN SETUP DATE]

Resident T_BDE_DAILY;

drop table T_BDE_DAILY;

I NEED TO DO A NOCONCATENATE FROM THE T_BDE_DAILY WITH THE FOLLOWING WHERE CLAUSE

T_BDE_DAILY_TM;

LOAD

[LOAN NUMBER],

[LOAN SETUP DATE],

FROM $(qvd_layer_2_path)T_BDE_DAILY.qvd(qvd)
where [Loss Mit Status Code] = 'A' ;

SINCE I NEED T_BDE_DAILY IN THE FINAL TABLE LOGIC, I AM NOT SURE HOW TO INTEGRATE THE TWO TABLES AS WELL AS WHICH TABLE TO DROP IN THE FINAL TAB.

Re: NoConcatenate Assistance - two table same information

Mon, 29 Dec 2014 16:43:39 GMT

Hi,

NoConcatenate -- use this

T_BDE_DAILY_TM;

Please check with this..

Sub2u

Re: NoConcatenate Assistance - two table same information

Mon, 29 Dec 2014 16:57:36 GMT

Hi,

Synthetic table & Synthetic keys will be created in table viewer.

So try to avoid that will change the column names or autonumber with the concatenate two fields...

Sub2u