topic Blocking Definition tRecordMatch in Data Quality https://community.qlik.com/t5/Data-Quality/Blocking-Definition-tRecordMatch/m-p/2274946#M3023 <P>Hi all,&nbsp;</P> <P>&nbsp;</P> <P>Anyone knows if it's possible use as blocking definition an interval on tRecordMatching component?</P> <P>&nbsp;</P> <P>For example, I mean:</P> <P>&nbsp;</P> <P>Main row</P> <TABLE width="149px"> <TBODY> <TR> <TD width="68px" height="56px">Name</TD> <TD width="81.6px" height="56px">Blocking Definition</TD> </TR> <TR> <TD width="68px" height="56px">Joseph Moreno</TD> <TD width="81.6px" height="56px">35050</TD> </TR> <TR> <TD width="68px" height="56px">Joe Moreno</TD> <TD width="81.6px" height="56px">35049</TD> </TR> <TR> <TD width="68px" height="56px">J. Moreno</TD> <TD width="81.6px" height="56px">35051</TD> </TR> <TR> <TD width="68px" height="29px">Mary Moreno</TD> <TD width="81.6px" height="29px">26013</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Lookup row:</P> <TABLE width="186"> <TBODY> <TR> <TD width="20">ID</TD> <TD width="83">Name</TD> <TD width="83">Blocking</TD> </TR> <TR> <TD>A</TD> <TD>José Moreno</TD> <TD>[35045 - 35055]</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>So, I need to use an interval between 35049 and 35051 as Blocking definition in the lookup and match the Name column by an algorithm&nbsp;</P> <P>&nbsp;</P> <P>Many thanks in advance!</P> Sat, 16 Nov 2024 01:57:02 GMT Jorjos 2024-11-16T01:57:02Z Blocking Definition tRecordMatch https://community.qlik.com/t5/Data-Quality/Blocking-Definition-tRecordMatch/m-p/2274946#M3023 <P>Hi all,&nbsp;</P> <P>&nbsp;</P> <P>Anyone knows if it's possible use as blocking definition an interval on tRecordMatching component?</P> <P>&nbsp;</P> <P>For example, I mean:</P> <P>&nbsp;</P> <P>Main row</P> <TABLE width="149px"> <TBODY> <TR> <TD width="68px" height="56px">Name</TD> <TD width="81.6px" height="56px">Blocking Definition</TD> </TR> <TR> <TD width="68px" height="56px">Joseph Moreno</TD> <TD width="81.6px" height="56px">35050</TD> </TR> <TR> <TD width="68px" height="56px">Joe Moreno</TD> <TD width="81.6px" height="56px">35049</TD> </TR> <TR> <TD width="68px" height="56px">J. Moreno</TD> <TD width="81.6px" height="56px">35051</TD> </TR> <TR> <TD width="68px" height="29px">Mary Moreno</TD> <TD width="81.6px" height="29px">26013</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Lookup row:</P> <TABLE width="186"> <TBODY> <TR> <TD width="20">ID</TD> <TD width="83">Name</TD> <TD width="83">Blocking</TD> </TR> <TR> <TD>A</TD> <TD>José Moreno</TD> <TD>[35045 - 35055]</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>So, I need to use an interval between 35049 and 35051 as Blocking definition in the lookup and match the Name column by an algorithm&nbsp;</P> <P>&nbsp;</P> <P>Many thanks in advance!</P> Sat, 16 Nov 2024 01:57:02 GMT https://community.qlik.com/t5/Data-Quality/Blocking-Definition-tRecordMatch/m-p/2274946#M3023 Jorjos 2024-11-16T01:57:02Z