Hey Tom, There's a couple different ways to do this. Probably the easiest would be to just have two different jobs, one that selects AD entries where (!(title=TERM)) and a different job that pulls entries where (title=TERM). In the first one, you use the title field and feed in the data. In the second job you set the entries with flags that will deactivate (set Status to "Offline"?), archive or delete the record as you determine necessary.
If absolutely need to do everything in one job, then I'd use a separate variable that will be used for setting the title value, something like checkedTitle. Your output step is set to use this variable. I recommend starting with the Regex Evaluation<http://wiki.pentaho.com/display/EAI/Regex+Evaluation> step. This will let you search and set a variable based on that search. The tricky part is that you want to set based on *not* finding the pattern "TERM". Set a flag variable (like flag_TERM) using Regex. Just set it to (TERM) and put your flag variable in for #1. This will set 'flag_TERM' to "TERM" if it is in the title attribute. Then test your flag variable. If it is blank, set 'checkedTitle' to the 'title' attribute value, if it isn't, then set it to your other value or do what you need to with that record. Kelly Logan Senior Consultant Rapid Technologies, Inc. <http://www.raptek.com/> ---------------------------------------------------------------------------- Date: Thu, 22 May 2014 10:38:51 -0400 From: Tom Siegel <[email protected]> Subject: Spoon LDAP_People Value substitution Hi All - I am working on a customized version of the LDAP_People transformation. I was wondering if someone could lead me in the proper direction regarding the following. I need to parse the stream values from the DMT_LDAP_INPUT step and look for the value "TERM" in the "title" AD attribute. If title = "TERM" I need to deactivate, archive, or delete the record (I haven't decided which is appropriate yet). If title != "TERM" I need to use the title value from the stream. Thanks, Tom _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
