List of Contributions

Ms. Laura Lacey

Contact Details

My Content

1 to 11 of 11 total

RE: Keyword search across full data set

Posted By Laura Lacey 05-20-2021 07:43
Found In Egroup: Data360 Analyze \ view thread
Thanks this almost works but then I'm losing where the cork was found in the original search by removing the match field. I need to know the records that contain cork and what field in matches with but remove all with Ireland. Should I then use a join to add the match field back for the cork?

RE: Keyword search across full data set

Posted By Laura Lacey 05-20-2021 07:43
Found In Egroup: Data360 Analyze \ view thread
Thanks this almost works but then I'm losing where the cork was found in the original search by removing the match field. I need to know the records that contain cork and what field in matches with but remove all with Ireland. Should I then use a join to add the match field back for the cork?

RE: Keyword search across full data set

Posted By Laura Lacey 05-20-2021 05:16
Found In Egroup: Data360 Analyze \ view thread
hello - on the flip side of this is there a way to exclude the matches so the node will only bring the data back where no hits were found? I now need to use the node where a word can match for example 'cork' and the follow up with exclude those that contain 'Ireland' within that data set. so either ...

RE: Keyword search across full data set

Posted By Laura Lacey 05-05-2021 03:55
Found In Egroup: Data360 Analyze \ view thread
That work! Many thanks

RE: Keyword search across full data set

Posted By Laura Lacey 05-04-2021 10:16
Found In Egroup: Data360 Analyze \ view thread
Thanks - but I require the records flagged rather than text replaced within the field. If the keyword is found the just bring the record back. how would I do this rather than replace?

Keyword search across full data set

Posted By Laura Lacey 05-04-2021 05:26
Found In Egroup: Data360 Analyze \ view thread
Is there a node that can look for specific keywords across my whole data set not just 1 field. as an added complication the keyword maybe found with in the field or set of text/numbers not as a word on its own.. eg in a data set of 330,000 rows and 57 fields I am looking for the word 'bank' it ...

RE: error importing excel files from directory node

Posted By Laura Lacey 12-08-2020 05:35
Found In Egroup: Data360 Analyze \ view thread
and no sheets have been deleted

error importing excel files from directory node

Posted By Laura Lacey 12-08-2020 04:51
Found In Egroup: Data360 Analyze \ view thread
I keep getting the below error on multiple excel imports - can you advise what this error is indicating? Sheet definition specifies an auto-indexed sheet. This resolves to index 1. However, this sheet does not exist in the input file T:\Group Fraud & RA\Lavastorm\2020 Projects\20.060 WIN ...

3.5.1 not finding network folders

Posted By Laura Lacey 11-06-2019 02:07
Found In Egroup: Data360 Analyze \ view thread
I've upgraded from 3.5 to 3.5.1 but I am no longer able to point input files to pick up from T:drive for example only C drive.

RE: Error in split and filter (is Not Null)

Posted By Laura Lacey 07-30-2019 04:14
Found In Egroup: Data360 Analyze \ view thread
removing the € does not help - also as per my ticket this worked yesterday but not today.

Error in split and filter (is Not Null)

Posted By Laura Lacey 07-29-2019 23:57
Found In Egroup: Data360 Analyze \ view thread
I keep getting an error on my data flow when using a split or filter node to look for Null values on a date field. This is the error: “Split‎ Error in node setup: java.lang.IllegalArgumentException: Cannot create PyString with non-byte value” The advanced ...