topic Distribute a Report based on Mailing list in Qlik Automate https://community.qlik.com/t5/Qlik-Automate/Distribute-a-Report-based-on-Mailing-list/m-p/2091046#M2128 <P>Hi all,</P> <P>using an Automation I want to loop through a field (PLANT) and generate a report for each field value. This is working so far. Anyway now I want to distribute these plant-specific reports to certain users. For support I have added a table to my model looking like this</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD>Plant ID</TD> <TD>Mail</TD> </TR> <TR> <TD width="50%" height="25px">PLANT A</TD> <TD width="50%" height="25px">test@mail.com</TD> </TR> <TR> <TD width="50%" height="25px">PLANT A</TD> <TD width="50%" height="25px">new_test@mail.com</TD> </TR> <TR> <TD width="50%" height="25px">PLANT B&nbsp;</TD> <TD width="50%" height="25px">report@mail.com</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>When looping through the Plants I would also expect that I can tell the automation to use only the associated values from the field "Mail". I tried a variable that I created in the script but this doesn't work. Anyone can help?</P> Fri, 15 Nov 2024 21:29:49 GMT christoph_suessmann 2024-11-15T21:29:49Z Distribute a Report based on Mailing list https://community.qlik.com/t5/Qlik-Automate/Distribute-a-Report-based-on-Mailing-list/m-p/2091046#M2128 <P>Hi all,</P> <P>using an Automation I want to loop through a field (PLANT) and generate a report for each field value. This is working so far. Anyway now I want to distribute these plant-specific reports to certain users. For support I have added a table to my model looking like this</P> <TABLE border="1" width="100%"> <TBODY> <TR> <TD>Plant ID</TD> <TD>Mail</TD> </TR> <TR> <TD width="50%" height="25px">PLANT A</TD> <TD width="50%" height="25px">test@mail.com</TD> </TR> <TR> <TD width="50%" height="25px">PLANT A</TD> <TD width="50%" height="25px">new_test@mail.com</TD> </TR> <TR> <TD width="50%" height="25px">PLANT B&nbsp;</TD> <TD width="50%" height="25px">report@mail.com</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>When looping through the Plants I would also expect that I can tell the automation to use only the associated values from the field "Mail". I tried a variable that I created in the script but this doesn't work. Anyone can help?</P> Fri, 15 Nov 2024 21:29:49 GMT https://community.qlik.com/t5/Qlik-Automate/Distribute-a-Report-based-on-Mailing-list/m-p/2091046#M2128 christoph_suessmann 2024-11-15T21:29:49Z