List of Contributions

I'm inputting an excel spreadsheet with a lot of serialized column names such as DateInstalled1, DateInstalled2, DateInstalled3 as well as TotalBat1, TotalBat2, TotalBat3 and so on. I need to push DateInstalled2 and 3 column data to new records under DateInstalled1. I also need to pass a non serialized ...

The data source I'm connecting to is always pulling back a 5 character string, however, the actual data is not always 5 characters. It could be 3, 4, or 5. The data with less than 5 characters is padding with spaces to bring it to 5. Below is the script I created, however, it's not replacing the spaces, ...

Here is my Configure script: out1['Employee ID'] = fields['ps.EMPLID'] out1['Last Name'] = fields['ps.LAST_NAME'] out1['First Name'] = fields['ps.FIRST_NAME'] out1['Middle Initial'] = fields['ps.MIDDLE_NAME'] out1.Email = fields['ps.EMAIL_ADDR'] out1['Supervisor ID'] = fields['ps.SUPERVISOR_ID'] ...

I'm trying to replace "/" with " " if the string contains a "/", otherwise I want to use the default string value from the input node. I've tried various replace configurations with no luck. I'm new to Data360 but a longtime user of LAE. ------------------------------ Shawn Pelletier Knowledge Community ...