topic Nested loops - high time cost in QlikView https://community.qlik.com/t5/QlikView/Nested-loops-high-time-cost/m-p/437903#M1271856 <HTML><HEAD></HEAD><BODY><P>Ok, I'm stuck with this:</P><P></P><P>I got 2 table, and I need a Result table, just as shown below:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 311px;"><TBODY><TR><TD class="xl65" height="20" width="114">Table Groups</TD><TD><BR /></TD></TR><TR><TD height="19" style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #4f81bd;">GroupName</TD><TD class="xl64" style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #4f81bd;">StartRange</TD><TD class="xl64" style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #4f81bd;">EndRange</TD></TR><TR><TD height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">Bevarages</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">11001</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">11007</TD></TR><TR><TD height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">Food</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">21003</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">21010</TD></TR><TR><TD height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">Canned</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">301117</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">301118</TD></TR><TR><TD class="xl65" height="20"><P></P><P>Table Items</P></TD><TD><BR /></TD></TR><TR><TD class="xl64" height="19" style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #4f81bd;">IdItem</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #4f81bd;">Desc</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">11001001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Coke</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">11001002</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">7up</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">11001003</TD><TD colspan="2" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Absolut Vodka</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">11001004</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Duff</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">21003001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Ruffles</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">21003002</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Pringles</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">30117005</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Beans</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">30117006</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Green Corn</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">30118001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Souce</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">99903001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Trim</TD><TD><BR /></TD></TR><TR><TD class="xl65" height="20"><P></P><P>Result Table</P></TD><TD><BR /></TD></TR><TR><TD class="xl64" height="19" style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #4f81bd;">IdItem</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #4f81bd;">Desc</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #4f81bd;">GroupName</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">11001001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Coke</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Bevarages</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">11001002</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">7up</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Bevarages</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">11001003</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Absolut Vodka</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Bevarages</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">11001004</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Duff</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Bevarages</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">21003001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Ruffles</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Food</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">21003002</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Pringles</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Food</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">30117005</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Beans</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Canned</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">30117006</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Green Corn</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Canned</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">30118001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Souce</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Canned</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">99903001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Trim</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">-</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>I did it with a&nbsp; "for..for...next...next" nested loop, but it took a life, and I have only 1mi rows.</P><P></P><P>Can anyone help me with this. I need a better way to do it.</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT rogeriogyn 2026-01-26T18:19:17Z Nested loops - high time cost https://community.qlik.com/t5/QlikView/Nested-loops-high-time-cost/m-p/437903#M1271856 <HTML><HEAD></HEAD><BODY><P>Ok, I'm stuck with this:</P><P></P><P>I got 2 table, and I need a Result table, just as shown below:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 311px;"><TBODY><TR><TD class="xl65" height="20" width="114">Table Groups</TD><TD><BR /></TD></TR><TR><TD height="19" style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #4f81bd;">GroupName</TD><TD class="xl64" style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #4f81bd;">StartRange</TD><TD class="xl64" style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #4f81bd;">EndRange</TD></TR><TR><TD height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">Bevarages</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">11001</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">11007</TD></TR><TR><TD height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">Food</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">21003</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">21010</TD></TR><TR><TD height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">Canned</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">301117</TD><TD align="right" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">301118</TD></TR><TR><TD class="xl65" height="20"><P></P><P>Table Items</P></TD><TD><BR /></TD></TR><TR><TD class="xl64" height="19" style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #4f81bd;">IdItem</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #4f81bd;">Desc</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">11001001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Coke</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">11001002</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">7up</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">11001003</TD><TD colspan="2" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Absolut Vodka</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">11001004</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Duff</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">21003001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Ruffles</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">21003002</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Pringles</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">30117005</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Beans</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">30117006</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Green Corn</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">30118001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Souce</TD><TD><BR /></TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">99903001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Trim</TD><TD><BR /></TD></TR><TR><TD class="xl65" height="20"><P></P><P>Result Table</P></TD><TD><BR /></TD></TR><TR><TD class="xl64" height="19" style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #4f81bd;">IdItem</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #4f81bd;">Desc</TD><TD style="font-size: 11pt; color: white; font-weight: bold; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #4f81bd;">GroupName</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">11001001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Coke</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Bevarages</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">11001002</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">7up</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Bevarages</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">11001003</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Absolut Vodka</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Bevarages</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">11001004</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Duff</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Bevarages</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">21003001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Ruffles</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Food</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">21003002</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Pringles</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Food</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">30117005</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Beans</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Canned</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">30117006</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Green Corn</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Canned</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7; background-color: #dce6f1;">30118001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Souce</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; background-color: #dce6f1;">Canned</TD></TR><TR><TD align="right" height="19" style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none solid solid; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7; border-left-width: 0.5pt; border-left-color: #95b3d7;">99903001</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid none; border-top-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">Trim</TD><TD style="font-size: 11pt; color: black; font-family: Arial; border-top-width: 0.5pt; border-style: solid solid solid none; border-top-color: #95b3d7; border-right-width: 0.5pt; border-right-color: #95b3d7; border-bottom-width: 0.5pt; border-bottom-color: #95b3d7;">-</TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>I did it with a&nbsp; "for..for...next...next" nested loop, but it took a life, and I have only 1mi rows.</P><P></P><P>Can anyone help me with this. I need a better way to do it.</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Nested-loops-high-time-cost/m-p/437903#M1271856 rogeriogyn 2026-01-26T18:19:17Z Re: Nested loops - high time cost https://community.qlik.com/t5/QlikView/Nested-loops-high-time-cost/m-p/437904#M1271859 <HTML><HEAD></HEAD><BODY><P>Have you looked at IntervalMatch()? </P></BODY></HTML> Wed, 17 Apr 2013 11:29:51 GMT https://community.qlik.com/t5/QlikView/Nested-loops-high-time-cost/m-p/437904#M1271859 jerrysvensson 2013-04-17T11:29:51Z