Assign values to specific cells in a created table in script editor
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
