Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can any one help me in
"How to add new columns into the existed table" in Qlikview?
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
In script?
TableSource:
load
....
from
...
;
TableSourceWithANewColumn:
load
*,
'value for new column' as NewColumnName
resident TableSource;
drop table TableSource;
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;
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
Thank You max..
Thank You for detailed info Ahmed..
Thank You Fer..