topic Combining 2 sets of different data from different source into 1 in QlikView

Combining 2 sets of different data from different source into 1

Wed, 07 Apr 2010 14:47:04 GMT

Two systems A & B. A = 1999 - 2009, B = 2010 and further. Export to csv.files A.csv and B.csv. I want to create a QV report in which both data is combined:

From system A product A booking lines with description field = DESC_A, system B = DESC_B.

I want to see details from both systems in one field = DESC_A_AND_B.

How do I manage to have data from both systems into 1 new field?

Combining 2 sets of different data from different source into 1

Thu, 08 Apr 2010 09:12:52 GMT

Hi,

try the following:

Load

'SystemA' as System,

DESC_A as Desc,

Field1 as Field

from TableB:

Load

'System_A' as System,

DESC_A as Desc,

Field_A as Field

from TableA:

Load

'System_B' as System,

DESC_B as Desc,

Field_B as Field

from TableB:

Are the number of fields and the field names exactly the same QlikView creates a single table.

Therefore field "System" comes in place to be able to identify the data (belongs to A or B).

Good luck!

Rainer