Add a field to a Table in the Script

[#1]

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

[swuehl]

Hi Nickh123,

you can use

Concatenate LOAD ...

to force qlikview to combine both tables.

Hope this helps,

Stefan

[#3]

hi,

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

ex:

AB:

laod table A

concatenate

tableB

[rahulgupta]

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