Hi people,
Is there a possibility in Script editor to assign specific values of a loaded table to specific cells in a newly created table? My Problem looks like the following:
I have data loaded from an SQL Database into QlikSense which look like the following:
See Image (This is just an an example)
I now would like to
1)assign specific values from different rows (from table1) to cells in one single row in a newly created table (table2).
2) assign specific text strings to cells in the newly created table (i.e. "n.a.")
I created the new table with Load Inline --> fieldnames
In Excel VBA one can use commands like :
Worksheets("sheetname1").cells(X,Y) = Worksheets("sheetname2").cells(A,B) Or
Worksheets("sheetname1").cells(X,Y) = "Random_text"
Currently i am going through the list (table1) with an "for i=1 to N" function
and with "if .. then... else" function to control certain conditions. But I don't know how to assign the string "n.a." to
specific cell.
I hope i described the problem comprehensible.
Thanks in advance
Morisson
