Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Add Columns to Table?

Hi,

Can any one help me in

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

1 Solution

Accepted Solutions
engishfaque
Specialist III
Specialist III

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

View solution in original post

6 Replies
maxgro
MVP
MVP

In script?

TableSource:

load

     ....

from

     ...

     ;

TableSourceWithANewColumn:

load

     *,

     'value for new column' as NewColumnName

resident TableSource;

drop table TableSource;

el_aprendiz111
Specialist
Specialist

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;

engishfaque
Specialist III
Specialist III

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

Not applicable
Author

Thank You max..

Not applicable
Author

Thank You for detailed info Ahmed..

Not applicable
Author

Thank You Fer..