I have a table/sheet in Excel I need to import into a database so I can work with it more efficiently. IU will have a # of ongoing add'l tasks once this is done as I have a lot of work to do after that (integrate/compare/relate to other tables mostly).
In a nutshell I have a main column which is set up as a hiearchy of data e.g
Group1
Group1.1
Group 1.1.1
Group2
Group 2.1
Group 2.1.1
Group 2.1.2
Group 2.1.2.1
etc.
except it was not #d as such, just done with indents. I have previously been able to get scripts that parse indents as levels so I know that can work.
So the first step would be simply to pull into a table where I can collapse/expand levels so I can simply *see* my data better.
I'd also like to easily be able to;
1) Add new data to any level and or change that level/indent/hierarchy easily
2) Move any given record up/down a level w or w/o it's children.
Finally, because many records were supposed to belong to more then one hierarchy and I was using Excel, I made a column called 'Add' Parents' where I would simply name the add'l assignment e.g. Group 1.2.1 might be assigned to Group 4.2.1.1 (again I did not name like this i.e. #s)
In a real db then that record would appear under both e.g
Group 1.2
Group 1.2.1
Group 4.2.1.1
Group 1.2.1
I'd like there for tthat column do do just that, to retain the values (so I can remove the re-asignemnt if I want) but also to appear where re-assigned.
There are a # of other columns which for now should simply travel with that record and keep their values which won't be used for anything until subsequent tasks.
I can provide a sample of data if necessary, pretty straightforward though I just want to be able to work with what has become unwieldy (3,000 records, many indents, many add'l assignments) more easily and efficeintly, as i say more tasks to come.