I am trying to join two tables of weather data generated by the JSON grabber by a common row value. In the attached example I am trying to join table 1 and table 2 by the common value of row.
Does anybody have any idea how to achieve this?
I have tried using a script and I can go as far as populating the new table's columns and pulling out each row of the original tables but I am struggling to populate the new table with new rows.
var timeStampRows = getTableRows("timeStampTable", 0, true); //Extract rows in table 1 var windTableRows = getTableRows("windTable", 0, true); //Extract rows in table 2 var TotalColumns:Array = new Array("row", "dt_txt", "temp_min", "temp_max", "temp", "humidity", "pressure", "speed", "deg", "all", "description", "main", "icon"); //Populate output table with columns for all data setTableColumns("outputTable", 0, TotalColumns);
I can then access each row and column using
where i is the row number and .speed is the speed column.
But how do I populate the new table?
I notice DGLux5 has a table join feature but I am unable to find such a thing in 2.5.
Attachment: download link