Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jonathandienst
Partner - Champion III
Partner - Champion III

Edit the LOAD statement to something like:

     LOAD

          Col_1,

          Col_2,

          Col_1 * Col_2 as Col3,

          ...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Chanty4u
MVP
MVP

just,

load

col1,

col2,

col1*col2 as col3

from datasouce;