Discussion Board for collaboration on QlikView Layout & Visualizations.
I have two fact table
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...
Load 'Table one' As SourceTable,
Resident [table one];
Load 'Table two' As SourceTable,
Resident [table two];
Drop Tables [table one], [table two];
The field SourceTable shows where the data came from
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' as Table_Flag
same for table two and then concat
hope that helps
edit: in the time of writing that GG beat me to it!
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
Yes the quotes are required,
otherwise QV will look for a field named PRD_YIELD_OP_TYPE_SUMMARY
in your source.