Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Edit the LOAD statement to something like:
LOAD
Col_1,
Col_2,
Col_1 * Col_2 as Col3,
...
just,
load
col1,
col2,
col1*col2 as col3
from datasouce;