Hi, my scripting isn't that great so forgive me.
I have an import set table that looks like this:
| u_department | u_rc |
| Accounting | 130 |
| HR | 202 |
| Serviceville | 101 |
I created a transform map that maps u_department and u_rc to name and id on the cmn_department table respectively. My cmn_department table looks like this:
| name | id |
| Accounting | |
| HR | 202 |
| Serviceville - Branch 20 |
|
Some departments in cmn_department are already complete, some are missing the ID, and some have " - Branch #"
appended to the name.
I'm trying to create an OnBefore Transform Script that will change source.u_department to target.name if target.name contains source.u_department. I would also like to skip the rows that completely match, and update the id of rows in cmn_department that are empty.
This is what I have, but it is just adding every single row in my import set to cmn_department with the name field for each row blank:
(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {
// Add your code here
if (target.name.toString().includes(source.u_department)) {
source.u_department = target.name.toString();
} else {
ignore = true;
}
})(source, map, log, target);
Thanks for any help!
