List of Contributions

Mike Spalding

Contact Details

My Content

1 to 13 of 13 total

Send email when Filter output finds data

Posted By Mike Spalding 05-05-2025 11:33
Found In Egroup: Data360 Analyze \ view thread
Hi, I have a filter node that is looking for a particular "last name" in a data set. If that last name is found, I'd like to put it in an Excel output file and email that file to me. If that last name is not found, just stop and do nothing more. I could also get away with taking the Excel node out ...

RE: Data3Sixty Data Flow time to complete

Posted By Mike Spalding 05-31-2024 10:52
Found In Egroup: Data360 Analyze \ view thread
Thanks Adrian! ------------------------------ Mike Spalding manager AbbVie Inc. ------------------------------

Data3Sixty Data Flow time to complete

Posted By Mike Spalding 05-02-2024 16:27
Found In Egroup: Data360 Analyze \ view thread
Hello, Is it possible to identify how long it takes a flow to run to completion? I see the timing on the Nodes but not on the entire flow/graph. I could use the 2nd hand on my watch but figured this data may be written somewhere in more detail. I am running on a server install. Thanks Mike ...

RE: Search for a Future Date using wildcards

Posted By Mike Spalding 04-23-2024 11:29
Found In Egroup: Data360 Analyze \ view thread
Thanks Ernest. I guess I was looking beyond the obvious. This will work for my needs for sure. Mike ------------------------------ Mike Spalding manager AbbVie Inc. ------------------------------

Search for a Future Date using wildcards

Posted By Mike Spalding 04-18-2024 14:18
Found In Egroup: Data360 Analyze \ view thread
Hello, I am looking for a solution to search for future (or past) dates using wildcards. For example, something like, Expense_Date > 203* or Expense_Date < 19* My overall goal is to find outliers in the Expense_Date field that need to be reviewed. So if I see an Expense_Date of 2048 ...

RE: Find special character and replace it and everything after it

Posted By Mike Spalding 02-13-2024 15:28
Found In Egroup: Data360 Analyze \ view thread
Thanks Jay and Steve, this worked! I appreciate the help. ------------------------------ Mike Spalding manager AbbVie Inc. ------------------------------

Field name with spaces

Posted By Mike Spalding 02-01-2024 14:38
Found In Egroup: Data360 Analyze \ view thread
Hello, Feel like this is pretty obvious but I can't figure it out. I'm adding a new field using a transform node. out1 += in1 out1.Feed_Identifier = str I really want my field name to be Feed Identifier. With a space between. It doesn't seem to like the space between the words so I've added the ...

RE: Strip characters from long string

Posted By Mike Spalding 01-17-2024 12:11
Found In Egroup: Data360 Analyze \ view thread
Thanks Adrian, this worked perfectly. ------------------------------ Mike Spalding manager AbbVie Inc. ------------------------------

Strip characters from long string

Posted By Mike Spalding 01-17-2024 10:58
Found In Egroup: Data360 Analyze \ view thread
Hello, I'm struggling finding this solution but it seems it should be pretty easy. I have a field (ExpenseID), which has a 45 character ID in it. I want to keep the first 15 characters and remove the remaining 30. ExpenseID 202312044989727202312044991783202312048590793 I'm looking for the first ...

Find special character and replace it and everything after it

Posted By Mike Spalding 09-28-2023 14:23
Found In Egroup: Data360 Analyze \ view thread
Hello, I'm working with some data where a PIPE "|" has been placed in the middle of the data. I'd like to remove the PIPE along with everything after it. Example Field Name is ProtocolNumber Content in field is M111-1234|2023-01-01 I want to remove the PIPE and the characters after the pipe, ...

RE: Highlight Expense Amount if Negative Match Found

Posted By Mike Spalding 08-22-2023 14:27
Found In Egroup: Data360 Analyze \ view thread
Adrian, this actually worked very well. Thanks for the help and the .INA file. ------------------------------ Mike Spalding Abbvie Inc. ------------------------------

Highlight Expense Amount if Negative Match Found

Posted By Mike Spalding 08-16-2023 11:48
Found In Egroup: Data360 Analyze \ view thread
Hello, I have a data set where I have positive expense amounts and negative expense amounts. I'd like to find a way to sort by the source ID and then look for a possible match. If found, mark the matching negative/positive so I can than research and adjust, if needed. Can D360 be used to sort the ...

Highlight Expense Amount if Negative Match Found

Posted By Mike Spalding 08-16-2023 11:47
Found In Library: Data360 Analyze