topic Re: Concatenate in QlikView

Concatenate

Thu, 22 Jan 2015 15:25:05 GMT

Hi,

I want to concatenate 3 tables with same column names and I have a date column also.Now I want to use one calendar for 3tables.But the problem is I should use resindent load in that calendar code and I have 3 date columns in 3 different tables.How can solve this problem?

Re: Concatenate

chrismarlow — Thu, 22 Jan 2015 15:31:09 GMT

If the tables have been concatenated is the date field not in the single resulting table?

Otherwise you need to concatenate the 3 date fields to a single temporary table, then use the calendar code, then drop the temporary table.

Re: Concatenate

Anonymous — Thu, 22 Jan 2015 15:34:38 GMT

if you have 3 different date fields and you ant a common date field you must rename the fields

Tmp:

load

DATEFIELD1 as DATEFIELD,

resident TABLE1;

concatenate load

DATEFIELD2 as DATEFIELD,

resident TABLE2

That what you want?

Re: Concatenate

Thu, 22 Jan 2015 15:59:01 GMT

Hi,

if you have concatenated the tables then your date field would also have been concatenated????

otherwise you can simply perform resident load on all the 3 particular date fields and then concatenate them...

Hope it solve your problem.

Regards