add a column to an existing table.

[vardhan1305]

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 ...

[vishsaggi]

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

[qlikviewwizard]

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;

[MarcoWedel]

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