You are not logged in.
I appreciate the offer. I actually created a small job that splits the "," delimited string of ids for each person and appends them to a globalMap ArrayList variable. Then, I used a rowGenerator to create rows for each variable in the globalMap arraylist. Each row has an incremented integer column, the string person-org id from the array, and a blank id column. A JavaRow object sets the long id to the string value. I can use that id to map the person-org tables via the ids and deactivate them. Once I got the GlobalMap arraylist working, the rest was pretty straightforward.
But, I never did find a way to directly map a list to a long That would be cool to do but also potentially dangerous.
Could you show me some data of Person and Person-Org?
Then i can create a job for you.
The scenario I am dealing with now is a Person record that has a link to a Person-Org record. So, the Person record has a column that is returned in Talend as a list of foreign keys to the Person-Org table. That's great. In order to deactivate the Person record the job must deactivate the Person-org entries first.
How can I map a list of ids to the primary id key in the Person-Org table? TMap won't allow me to do that and using an iteration of some kind is proving to be problematic.