How to copy a runtime data table column value to another data table
I am trying to copy a row value from a runtime data table to another runtime data table. I tried Get Parameter but it is not giving me the desired output.
Temp = Datatable.LocalSheet.GetParameter("Columnname").Value
I want to copy the entire value in the datatable 1 to datatable 2 during runtime
Table 1 has 3 rows including the header
Table 2 has two rows including the header
I want to append the table 1 values below table 2 values including the header. Basically I want to merge both the table values in to one including the header. The output should be like
Any suggestion on how can I do that?
Your statement looks fine assuming the source data is located on the LocalSheet of the action where the statement is located.
You can drop the value on a named datatable using GetSheet:
Datatable.GetSheet("sheetname").GetParameter("columnname").Value = Temp