Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
luca_bellotti
Contributor III
Contributor III

New column by script

Hello to everyone,

I've tried to solve this problem but I can't figure it out. Maybe someone  could help me.

I've loaded the TABLE1 by script editor

TABLE1

NAMEABCD

RED

100981050

What I need to obtain is a new table with another column  (E) with the following formula C+((A-B)/D)

TABLE2

NAMEABCDE

RED

10098105010,04

Thank everyone who might help me.

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Hi,

try this:

Table1:

load

.

.

FROM

TABLE2:

LOAD

C+((A-B)/D) as E

resident Table1;



View solution in original post

3 Replies
YoussefBelloum
Champion
Champion

Hi,

try this:

Table1:

load

.

.

FROM

TABLE2:

LOAD

C+((A-B)/D) as E

resident Table1;



luca_bellotti
Contributor III
Contributor III
Author

It worked. Thank you Youssef.

YoussefBelloum
Champion
Champion

You're welcome