topic Re: How to Add Columns to Table? in QlikView

How to Add Columns to Table?

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can any one help me in

"How to add new columns into the existed table" in Qlikview?

Re: How to Add Columns to Table?

maxgro — Fri, 28 Oct 2016 18:19:20 GMT

In script?

TableSource:

load

....

from

...

;

TableSourceWithANewColumn:

load

'value for new column' as NewColumnName

resident TableSource;

drop table TableSource;

Re: How to Add Columns to Table?

el_aprendiz111 — Fri, 28 Oct 2016 22:06:12 GMT

Hi,

1 example:

[TABLE]:

LOAD * Inline

[

FIELD,FIELDa,FIELDb,VALUE

LOLA, ALVAREZ,XDASD, 879

PEDRO, RODR, XCZC, 200

YULI, FGDS, ZCX, 300

YULI, FGDS, ZCX, 1458

YULI, FGDS, ZCX, 453

LEIDY, BUITRAGO,CZXC, 6

];

NEW_TABLE:

LOAD *,

RowNo() AS ID ,

AutoNumberHash128(FIELD & FIELDa) AS NEW_ID,

FIELD & ' ' & FIELDa AS NEW_FIELD

Resident TABLE ;

DROP Table TABLE;

EXIT Script;

Re: How to Add Columns to Table?

engishfaque — Mon, 31 Oct 2016 04:14:27 GMT

Hi Sujitha,

It would be nice if you share us little bit more information for adding new Column (Field Name) in a Table.

If you are looking for solution at script level, then we have many ways to Add new Columns (Field Name) in existing Table by using old Column (Field Name). Listed below are the solutions,

Field Renaming

1. AS

2. ALIAS

3. Qualifier / UnQualifier

4. Rename

Joins (Append Columns)

1. Left Join

2. Right Join

3. Inner Join

4. Outer Join

Keep

1. Left Keep

2. Right Keep

3. Inner Keep

If you are looking for solution at UI level, Add Dimension or Expression in your Straight Table / Pivot Table.

Kind regards,

Ishfaque Ahmed

Re: How to Add Columns to Table?

Tue, 01 Nov 2016 08:01:26 GMT

Thank You max..

Re: How to Add Columns to Table?

Tue, 01 Nov 2016 08:02:50 GMT

Thank You for detailed info Ahmed..

Re: How to Add Columns to Table?

Tue, 01 Nov 2016 08:03:32 GMT

Thank You Fer..