About audrey

audrey

If your goal is to identify strings that have just 1 letter difference, maybe it's easier to use a distance function in an Expression node. Because when you make changes to the matching definition, it can have a large impact. For your example, you could be updating the Phonetics library to say "F" ans "S" are similar in sound, and that would fix this specific issue. But it would have a much bigger impact and could trigger lots of false positives. I don't think there is a easy fix without knowing your data and requirements. Audrey

audrey

You might want to customized the QKB definition to fit your needs if the existing one doesn't. Take a look at this video for a quick introduction https://www.youtube.com/watch?v=TdvKDVdBrdk Hope this helps, Audrey

audrey · ‎06-11-2025

Hi, So in your MatchCode node, you can go to the "Additional Fields" at the bottom left and there you decide if you want to add some of your input fields because, I think, by default MatchCode node will not pass all the input fields. I'm puzzled by the duplicating that "fixes" the issue, I don't think I've already seen that. If you'd like to investigate more accurately, maybe open a Tech Support ticket? Hope this helps, Audrey

audrey · ‎10-02-2024

Can you please give a bit more context on where the job is running, since when you're seeing this problem? Thanks, Audrey

audrey · ‎10-02-2024

Hi, It looks like you're trying to use a custom definition (xxxx FIRSTNAME without prefix). Either this definition is not available in your QKB, or it exists but you didn't select the "Surface" option. Hope this helps, Audrey

audrey · ‎12-12-2023

I don't think there's anything pre-build to calculate the max of a list of records. The max function exists in EEL but will take values as arguments, so not what you need. You can try to use some simple code in the Expression node //Pre-Expression //Setting variables boolean isMaxVal; hidden integer prevMaxVal; isMaxVal= false; prevMaxVal=0; //Expression if `Frequency` >= prevMaxVal begin isMaxVal = true; prevMaxVal=`Frequency`; end else isMaxVal=false; This might require your data to be sorted though. The same logic could apply to the latest value. Does this help?

audrey · ‎12-12-2023

Hi, I am not sure I completely understand what you're trying to achieve. If you can give an example of the data you have in input and the output you expect, I can take a look at what can be done with the Expression node. Audrey

audrey · ‎09-14-2022

Hi, Have you tried to use the Surviving Record Identification node? It's meant to keep only one record per cluster, based on some conditions. Hope this helps.

audrey · ‎08-22-2022

You might also want to check the disk space that is available during the job run. Especially when you're near of the usual error point.

audrey · ‎08-18-2022

Hi, There are no definition in the QKB to match and cluster records by age. Also, I thought about your use case and I think it's not a good solution. Let me explain what could happen: -> customer A is 20 and matches customer B who is 25, -> but customer C is 30, and therefore matches customer B, -> and, customer D is 35 and therefore matches customer C. In the end, A matches D, and you'll end up one big cluster with all of your records. So I think age should not be used this way. Maybe there are other criteria in your data that would be better. Hope this helps. Audrey

audrey · ‎08-08-2022

Hi, Regarding the null/blank values, did you try to use the following options in the Match Code node: -> Generate null match codes for blank field values -> Preserve null values? Regarding the age, it will not work to use a Text type match code definition. You might want to create a simple function in Expression node to return true/false if the age is in a 10 years range. Hope this helps. Audrey

audrey · ‎08-08-2022

Hi, In the Properties of your Work Table Reader, make sure you have added your new column. Then, in the Data Job that contains it, go to the Inputs tab, open the Source Binding for your Work Table Reader and go to the Column Mappings table. Take a look at the example below, and let me know if this helps Thanks, Audrey

audrey · ‎08-05-2022

I'm not really sure what that shows. Is this the total amount of free space on the disk before the job runs? during the run? when it fails? In any case, that doesn't seem enough. ALso, didn't you say you got more space on the machine?

audrey · ‎08-03-2022

It's difficult to predict the amount needed as this depends on many factors like the number of records, their size, the number of matching conditions, the size of the clusters (= how many records end in a group), etc. However I believe 3 TB should be enough and if it's still failing, I would encourage you to open a ticket with Technical Support so they can investigate.

audrey · ‎08-02-2022

That would be in the File System of your DMServer machine.

Online Status	Offline
Date Last Visited	3 weeks ago