Hi. I have created 2 tables through data manager.
Table 1 has one category value with a category-grouping value added to each. (like category 1-3, "good group", category 4,5, 6 "bad group".
Table 2 also has category like category 1-3. But also under-category for each category. Thereby creating lots of more rows.
When i concatenated the first table with the 2nd I just end up giving "good group", "bad group" and so on on the same amount of rows like in table 1. Rest of the lines created by under-category values for each categery-values just gives null.
Few basic questions;
1. Can I and how do I connect and manipulate a table created in data manager with script? (without unlocking auto script). Do I need to connect and write load statement like I do normally in script?
2. Do I solve this task best by concatenating in the script? In that case. Can someone provide a short example how to do it?
It is data from 2 different excel files. Very greatful for help!
