to create extra fields in the load script you only need to add some thing like this.
null() as Extra_Field.
you can replace the null for the rowno() function that counts the amount of row's. this will create the 1,2,3,4 you are after but realistically this wouldn't be the right key. is there something in your datasets that match? (even when combining columns?)
why wouldn't this be the right key. let's say your dataset looks like this:
rowno
data
1
a
2
a
3
a
4
a
rowno
data
1
b
2
b
3
b
4
b
after an update of the data the data might look something like this:
I have had a look through the dataset and there is one column that has an ID that connects the parent and child. But it is a stand alone ID rather than an ID for the parent and an ID for the child.
To do an org chart, it looks like I need two ID's so is there a way I can duplicate this stand alone ID so that I have 2 versions of the same ID and just rename the columns perhaps?
