topic Re: Generating a table from two existing ones in App Development https://community.qlik.com/t5/App-Development/Generating-a-table-from-two-existing-ones/m-p/1986315#M81483 <P>Hi, just join these two tables. Like:</P> <LI-CODE lang="markup">NoConcatenate New_table: LOAD Date RESIDENT your_Date_table; JOIN LOAD Ticker RESIDENT your_Ticker_table; DROP TABLES your_Date_table, your_Ticker_table; </LI-CODE> Wed, 28 Sep 2022 06:16:51 GMT justISO 2022-09-28T06:16:51Z Generating a table from two existing ones https://community.qlik.com/t5/App-Development/Generating-a-table-from-two-existing-ones/m-p/1986087#M81451 <P>Dear all, need some help with the following.</P> <P>I have a Date Table&nbsp;</P> <TABLE width="68"> <TBODY> <TR> <TD width="68">Date</TD> </TR> <TR> <TD>1/1/2021</TD> </TR> <TR> <TD>1/2/2021</TD> </TR> <TR> <TD>1/3/2021</TD> </TR> <TR> <TD>1/4/2021</TD> </TR> <TR> <TD>1/5/2021</TD> </TR> <TR> <TD>1/6/2021</TD> </TR> <TR> <TD>1/7/2021</TD> </TR> <TR> <TD>1/8/2021</TD> </TR> <TR> <TD>1/9/2021</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>And I have a Table that holds stock tickers</P> <TABLE style="border-collapse: collapse; width: 48pt;" border="0" width="64" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 15.0pt;"> <TD width="64" height="20" style="height: 15.0pt; width: 48pt;">Ticker</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">AAA</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">BBB</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">CCC</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">DDD</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;">EEE</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I would like to generate a Table that holds all tickers for each date:</P> <TABLE width="128"> <TBODY> <TR> <TD colspan="2" width="128">New Table</TD> </TR> <TR> <TD>Date</TD> <TD>Ticker</TD> </TR> <TR> <TD>1/1/2021</TD> <TD>AAA</TD> </TR> <TR> <TD>1/1/2021</TD> <TD>BBB</TD> </TR> <TR> <TD>1/1/2021</TD> <TD>CCC</TD> </TR> <TR> <TD>1/1/2021</TD> <TD>DDD</TD> </TR> <TR> <TD>1/1/2021</TD> <TD>EEE</TD> </TR> <TR> <TD>1/2/2021</TD> <TD>AAA</TD> </TR> <TR> <TD>1/2/2021</TD> <TD>BBB</TD> </TR> <TR> <TD>1/2/2021</TD> <TD>CCC</TD> </TR> <TR> <TD>1/2/2021</TD> <TD>DDD</TD> </TR> <TR> <TD>1/2/2021</TD> <TD>EEE</TD> </TR> </TBODY> </TABLE> Tue, 27 Sep 2022 14:19:27 GMT https://community.qlik.com/t5/App-Development/Generating-a-table-from-two-existing-ones/m-p/1986087#M81451 Sundi 2022-09-27T14:19:27Z Re: Generating a table from two existing ones https://community.qlik.com/t5/App-Development/Generating-a-table-from-two-existing-ones/m-p/1986315#M81483 <P>Hi, just join these two tables. Like:</P> <LI-CODE lang="markup">NoConcatenate New_table: LOAD Date RESIDENT your_Date_table; JOIN LOAD Ticker RESIDENT your_Ticker_table; DROP TABLES your_Date_table, your_Ticker_table; </LI-CODE> Wed, 28 Sep 2022 06:16:51 GMT https://community.qlik.com/t5/App-Development/Generating-a-table-from-two-existing-ones/m-p/1986315#M81483 justISO 2022-09-28T06:16:51Z