topic Re: FIELD? in QlikView

FIELD?

Wed, 12 Nov 2014 05:17:07 GMT

HOW TO ADD AN EXTRA FIELD TO AN EXISTING TABLE?

anbu1984 — Wed, 12 Nov 2014 05:22:03 GMT

T1:

Load *,'NewField' As NewField Resident Table;

its_anandrjs — Wed, 12 Nov 2014 05:22:39 GMT

Hi,

There are many ways a

1. A field based on current field

Load

Field1

If(Field1='A',Field1) as NewField

From LOcation

2. By any resident load

Load * From Location;

join

Load ID,1 as Newfield resident A;

Regards

Anand

Wed, 12 Nov 2014 05:42:20 GMT

thanks bro

Wed, 12 Nov 2014 05:45:54 GMT

pls close this thread

ashfaq_haseeb — Wed, 12 Nov 2014 06:11:10 GMT

Hi,

Try like this

Load *,

'Flag' As NewField FromTable;

Regards

ASHFAQ