topic Creating new column by adding or subtracting value in other columns in QlikView

Creating new column by adding or subtracting value in other columns

Wed, 25 Nov 2020 16:16:04 GMT

Hi All!!

is it possible to make another column by adding or subtracting other two columns?

for example, let's say by Outer Joining I got three columns col1, col2, col3

Can I make col4 by col1 - col2?

Gysbert_Wassenaar — Tue, 06 Dec 2016 10:07:54 GMT

NewTable:

LOAD

col1, col2, col1 - col2 as col3

RESIDENT

OldTable;

DROP TABLE OldTable;