topic Add a field to a Table in the Script in QlikView

Add a field to a Table in the Script

Wed, 20 Jul 2011 10:13:57 GMT

Hi,

I have two tables (Table A and Table B) that I want to combine in qlikview. Both tables have exactly the same fields in them except table A has one extra field. How can I add this field to Table B in the load script so that they can be loaded as one table

Add a field to a Table in the Script

swuehl — Wed, 20 Jul 2011 10:18:22 GMT

Hi Nickh123,

you can use

Concatenate LOAD ...

to force qlikview to combine both tables.

Hope this helps,

Stefan

Add a field to a Table in the Script

Wed, 20 Jul 2011 10:26:55 GMT

hi,

Load table A and concatenate table B with it under a flag name

ex:

AB:

laod table A

concatenate

tableB

Add a field to a Table in the Script

rahulgupta — Wed, 20 Jul 2011 11:38:22 GMT

Hey Hi,

Solution to your problem:

Lets take a scenario where tableA has three fields(Field1,Field2,Field3) and tableB has only 2 fields

(Field1,Field2), then we add a new field as follows which automatically concatenate the two tables:

FinalTable:

Load

Field1,

Field2,

Field3

from TableA;

Load

Field1,

Field2,

'' as Field3

from TableB;

Hope this helps

Regards