Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

How to create a new field in data load editor

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?

2 Replies
MVP
MVP

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

Edit the LOAD statement to something like:

     LOAD

          Col_1,

          Col_2,

          Col_1 * Col_2 as Col3,

          ...

sureshqv
Esteemed Contributor III

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

just,

load

col1,

col2,

col1*col2 as col3

from datasouce;