Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to understand the data load editor a bit better (though I've been primarily using Data Manager).
Can someone explain what the following actually means? It's the text that shows up right at the beginning of the auto generated script.
For each name in $(dataManagerTables)
Let index = 0;
Let currentName = name;
Let tableNumber = TableNumber(name);
Let matches = 0;
Do while not IsNull(tableNumber) or (index > 0 and matches > 0)
index = index + 1;
currentName = name & '-' & index;
tableNumber = TableNumber(currentName)
matches = Match('$(currentName)', $(dataManagerTables));
Loop
If index > 0 then
Rename Table '$(name)' to '$(currentName)';
EndIf;
Next;
Set dataManagerTables = ;
Unqualify *;
Thanks!
The Data Load Editor allows you to combine script that you have written with script that is auto-generated by the Data Manager. Script that you have written should come before the auto-generated script. What that bit of code is doing is checking to see if there are any tables in the auto-generated script that have the same names as tables in your script and renaming them. For example, if you have a created a Products table, and there is a Products table in the auto-generated script, the auto-generated Products table will be renamed to Products-1.
The Data Load Editor allows you to combine script that you have written with script that is auto-generated by the Data Manager. Script that you have written should come before the auto-generated script. What that bit of code is doing is checking to see if there are any tables in the auto-generated script that have the same names as tables in your script and renaming them. For example, if you have a created a Products table, and there is a Products table in the auto-generated script, the auto-generated Products table will be renamed to Products-1.