topic Re: add a column to an existing table. in QlikView

add a column to an existing table.

vardhan1305 — Wed, 25 Nov 2020 16:16:04 GMT

i need to add ROP_Days column to Detl table . Can you please help me out.

IDS:

LOAD ShortID,

Month,

Chr,

PrimMfr,

CommCode,

AWC,

Days,

Date,

ROP_Days,

ROP_Date,

Code

FROM ....

Detl:

LOAD

Description,

ShortID,

Branch,

Transaction,

Type,

Line,

Supplier,

From ...

Re: add a column to an existing table.

vishsaggi — Sun, 17 Jun 2018 03:32:08 GMT

‌your IDS table and detl table is joined based on ShortID so you can use your RoP_Days anyways.

Re: add a column to an existing table.

qlikviewwizard — Sun, 17 Jun 2018 04:26:56 GMT

Hi,

Use INNER JOIN Or LEFT JOIN as per your requirement.

IDS:

LOAD ShortID,

Month,

Chr,

PrimMfr,

CommCode,

AWC,

Days,

Date,

ROP_Days,

ROP_Date,

Code

FROM Table_A;

INNER (IDS)

Detl:

LOAD

Description,

ShortID,

Branch,

Transaction,

Type,

Line,

Supplier,

From Table_B;

Re: add a column to an existing table.

MarcoWedel — Sun, 17 Jun 2018 18:06:02 GMT

Why do you need to add ROP_Days column to Detl table?