Forum Discussion
Replacing ID?
The above is all one company, just split by the 'Product_Family__c' column. Payroll is always the main product family.
What I'm attempting to do is take the 'System_ID_c' value for payroll (1405) and populate it into the HRIS field which has a null. Is there any way to do that? I will need to ensure that for each company, the HRIS 'System_ID_c' field matches that of the payroll field.
3 Replies
Anonymous is it always 1405 for null values?
parry2k no it is not. For rows that will have the value 'HRIS' for the 'Product_Family_c' column, the 'System_ID_c' value will always be null. I'm trying to find some kind of way to populate the HRIS null system id value with whatever the value is for the payroll system id.
parry2k No worries, I have figured out a solution.
