topic how do i concat multiple fact table with same field with a flag? in QlikView

how do i concat multiple fact table with same field with a flag?

sushil353 — Tue, 06 Sep 2011 13:27:06 GMT

Hi All,

I have two fact table

table one:

location_code

area_code

time_id

defects

processed

table two;

location_code

area_code

time_id

defects

processed

failure

and dimensions are time,location and area

how would i concat them into a single table such that after concating i am able to know which field is from which table....(means how do i add flag)

Please help me out...

Thanks

Re: how do i concat multiple fact table with same field with a flag?

gandalfgray — Tue, 06 Sep 2011 13:37:03 GMT

Hi Sushil

NewTable:

Load 'Table one' As SourceTable,

location_code,

area_code,

time_id,

defects,

processed

Resident [table one];

Concatenate (NewTable)

Load 'Table two' As SourceTable,

location_code,

area_code,

time_id,

defects,

processed,

failure

Resident [table two];

Drop Tables [table one], [table two];

The field SourceTable shows where the data came from

hth/gg

Re: how do i concat multiple fact table with same field with a flag?

Tue, 06 Sep 2011 13:41:21 GMT

So you basically want to a full list of 'location_code' from both tables for example but still see which it came from originally?

I think you should just be able to add an identifer to each table before you concat them

table one:

load

location_code,

area_code,

time_id,

defects,

processed,

'table one' as Table_Flag

same for table two and then concat

hope that helps

Joe

edit: in the time of writing that GG beat me to it!

how do i concat multiple fact table with same field with a flag?

sushil353 — Tue, 06 Sep 2011 13:48:33 GMT

Hi GG..

Thanks

Is it required to keep table name in single quotes

as my table name is PRD_YIELD_OP_TYPE_SUMMARY

so i am doing like

'PRD_YIELD_OP_TYPE_SUMMARY' as sourcePrdYield

how do i concat multiple fact table with same field with a flag?

gandalfgray — Tue, 06 Sep 2011 13:51:58 GMT

Yes the quotes are required,

otherwise QV will look for a field named PRD_YIELD_OP_TYPE_SUMMARY

in your source.

/gg