topic Re: How to create a new field in data load editor in App Development

How to create a new field in data load editor

Thu, 31 Mar 2016 22:23:47 GMT

I have a table and I want to add a new column to the table.

Example table

Col_1 Col_2

1 2

2 2

3 3

and i want to make this:

where col_3 is the product of 1 and 2 (in reality i want to use a much more complicated equation)

Col_1 Col_2 Col_3

1 2 2

2 2 4

3 3 9

how do you write/calculate/create new fields in the data load editor of qliksense?

jonathandienst — Fri, 01 Apr 2016 06:49:35 GMT

Edit the LOAD statement to something like:

LOAD

Col_1,

Col_2,

Col_1 * Col_2 as Col3,

...

Chanty4u — Fri, 01 Apr 2016 06:50:41 GMT

just,

load

col1,

col2,

col1*col2 as col3

from datasouce;