<se:hidden rem="generate a datatable with random values">
    {math.setrandomseed(1, rem="set seed to ensure data is identical for each rendering")}
    {buffer.set(dt, datatable.createempty(Row,Number,Date,Text))}
    {buffer.set(wordcnt, 20, rem="max word count for random text")}
    <se:for from="1" to="100" rem="to-parameter is the rowcount for the output datatable">
        {buffer.set(rnd, math.random($wordcnt))}
        <se:lorem save="lorem" rem="calculate random text"
            unitcount="{buffer.get(wordcnt)}" unittype="word"
            skiprows="{buffer.get(rnd)}" maxrows="{math.random($wordcnt-$rnd)}" rowformat="{this.field(1)}" rowdelimiter=" "
        />
        {datatable.rows.add($dt
        ,this.index()
        , math.random(1000)
        , datetime.addseconds( datetime.addhours(convert.todate('2010-01-01T00:00:00'), math.random(100000)-50000),math.random(10000)-5000)
        , $lorem
        )}
    </se:for>
</se:hidden>

<se:format inputdata="dt" rem="render datatable as a html table">
    <se:rowformat>
        <se:colformat><td>{this.field()}</td></se:colformat>
        <se:rowresult>{char.tab()}<tr>{this.rowresult()}</tr>{char.crlf()}</se:rowresult>
    </se:rowformat>

    <se:captionformat match="first">
        <se:colformat><th>{this.colname()}</th></se:colformat>
        <se:rowresult>{char.tab()}<tr>{this.rowresult()}</tr>{char.crlf()}</se:rowresult>
    </se:captionformat>

    <se:resultformat><table>{char.crlf()}{this.result()}</table></se:resultformat>
</se:format>

<table>
    <tr><th>Row</th><th>Number</th><th>Date</th><th>Text</th></tr>
    <tr><td>1</td><td>467</td><td>2013-02-05T17:26:15</td><td>consectetuer</td></tr>
    <tr><td>2</td><td>944</td><td>2005-06-14T14:23:45</td><td>ullamcorper, lorem vel feugiat</td></tr>
    <tr><td>3</td><td>320</td><td>2015-08-03T17:30:21</td><td>Lorem ipsum dolor sit amet,</td></tr>
    <tr><td>4</td><td>615</td><td>2012-05-01T01:33:38</td><td>convallis, dolor</td></tr>
    <tr><td>5</td><td>161</td><td>2008-08-27T05:49:40</td><td></td></tr>
    <tr><td>6</td><td>307</td><td>2013-09-08T00:04:25</td><td>sit amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet</td></tr>
    <tr><td>7</td><td>699</td><td>2004-06-14T10:21:59</td><td>vel feugiat convallis, dolor lectus laoreet sapien,</td></tr>
    <tr><td>8</td><td>62</td><td>2010-03-01T23:04:13</td><td>laoreet sapien, eu porta</td></tr>
    <tr><td>9</td><td>691</td><td>2008-09-15T12:49:03</td><td>consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu porta</td></tr>
    <tr><td>10</td><td>473</td><td>2007-02-01T11:35:35</td><td>dolor lectus laoreet sapien,</td></tr>
    <tr><td>11</td><td>346</td><td>2012-03-09T17:42:31</td><td>vel</td></tr>
    <tr><td>12</td><td>85</td><td>2015-05-28T13:58:01</td><td>sit amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu porta</td></tr>
    <tr><td>13</td><td>120</td><td>2006-09-30T13:51:01</td><td></td></tr>
    <tr><td>14</td><td>306</td><td>2015-09-06T15:02:39</td><td>adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis,</td></tr>
    <tr><td>15</td><td>101</td><td>2006-05-04T10:48:10</td><td>laoreet</td></tr>
    <tr><td>16</td><td>775</td><td>2015-02-09T02:57:05</td><td></td></tr>
    <tr><td>17</td><td>62</td><td>2009-08-27T01:36:42</td><td>lorem vel feugiat</td></tr>
    <tr><td>18</td><td>7</td><td>2011-05-09T15:56:06</td><td>Sed ullamcorper, lorem vel</td></tr>
    <tr><td>19</td><td>88</td><td>2004-08-06T11:04:23</td><td>sapien, eu porta</td></tr>
    <tr><td>20</td><td>476</td><td>2007-09-22T12:57:04</td><td>amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien,</td></tr>
    <tr><td>21</td><td>475</td><td>2008-07-02T22:09:33</td><td>dolor sit amet, consectetuer adipiscing elit. Sed</td></tr>
    <tr><td>22</td><td>167</td><td>2007-04-18T07:49:52</td><td>adipiscing</td></tr>
    <tr><td>23</td><td>137</td><td>2014-01-03T01:22:40</td><td>lectus</td></tr>
    <tr><td>24</td><td>651</td><td>2014-01-17T10:33:13</td><td>adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu porta</td></tr>
    <tr><td>25</td><td>688</td><td>2006-02-19T15:39:53</td><td>porta</td></tr>
    <tr><td>26</td><td>74</td><td>2007-08-21T08:10:30</td><td>Lorem ipsum</td></tr>
    <tr><td>27</td><td>474</td><td>2013-09-17T02:22:39</td><td>ipsum dolor sit amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu</td></tr>
    <tr><td>28</td><td>694</td><td>2014-09-14T11:45:41</td><td>dolor sit amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien,</td></tr>
    <tr><td>29</td><td>745</td><td>2006-05-05T17:50:36</td><td>adipiscing elit. Sed</td></tr>
    <tr><td>30</td><td>237</td><td>2004-08-23T05:11:22</td><td>dolor lectus laoreet sapien,</td></tr>
    <tr><td>31</td><td>622</td><td>2011-02-26T14:06:46</td><td>consectetuer adipiscing elit.</td></tr>
    <tr><td>32</td><td>314</td><td>2008-04-13T06:05:49</td><td>feugiat convallis, dolor lectus laoreet sapien,</td></tr>
    <tr><td>33</td><td>875</td><td>2004-12-23T11:36:01</td><td>sit amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu porta</td></tr>
    <tr><td>34</td><td>312</td><td>2014-01-20T06:02:28</td><td>sapien, eu</td></tr>
    <tr><td>35</td><td>739</td><td>2013-06-05T14:40:09</td><td>ullamcorper, lorem vel</td></tr>
    <tr><td>36</td><td>509</td><td>2005-03-08T08:33:04</td><td>lectus laoreet sapien, eu</td></tr>
    <tr><td>37</td><td>44</td><td>2012-07-24T18:16:52</td><td>Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu</td></tr>
    <tr><td>38</td><td>873</td><td>2011-08-26T04:45:03</td><td></td></tr>
    <tr><td>39</td><td>345</td><td>2008-08-07T19:03:16</td><td>ullamcorper, lorem vel feugiat convallis, dolor</td></tr>
    <tr><td>40</td><td>685</td><td>2013-09-08T12:19:26</td><td>adipiscing elit. Sed ullamcorper,</td></tr>
    <tr><td>41</td><td>382</td><td>2006-01-26T23:52:40</td><td></td></tr>
    <tr><td>42</td><td>822</td><td>2006-10-23T13:50:15</td><td></td></tr>
    <tr><td>43</td><td>236</td><td>2004-06-03T01:01:27</td><td></td></tr>
    <tr><td>44</td><td>150</td><td>2005-06-03T05:59:08</td><td>consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu porta</td></tr>
    <tr><td>45</td><td>668</td><td>2009-05-16T10:49:24</td><td>lorem vel feugiat convallis, dolor lectus laoreet sapien, eu</td></tr>
    <tr><td>46</td><td>362</td><td>2014-10-20T11:46:03</td><td>porta</td></tr>
    <tr><td>47</td><td>686</td><td>2013-08-30T23:36:32</td><td>Sed</td></tr>
    <tr><td>48</td><td>889</td><td>2011-06-20T14:38:14</td><td>ipsum dolor sit amet, consectetuer adipiscing elit. Sed ullamcorper, lorem</td></tr>
    <tr><td>49</td><td>652</td><td>2006-08-12T18:20:11</td><td>elit. Sed ullamcorper, lorem vel feugiat</td></tr>
    <tr><td>50</td><td>334</td><td>2006-11-26T22:16:26</td><td>consectetuer adipiscing elit. Sed</td></tr>
    <tr><td>51</td><td>587</td><td>2008-01-16T21:38:58</td><td>elit. Sed</td></tr>
    <tr><td>52</td><td>938</td><td>2012-07-02T05:02:40</td><td>sit amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis,</td></tr>
    <tr><td>53</td><td>901</td><td>2006-03-02T18:41:39</td><td>Lorem ipsum</td></tr>
    <tr><td>54</td><td>415</td><td>2011-09-24T21:51:07</td><td>dolor lectus laoreet</td></tr>
    <tr><td>55</td><td>522</td><td>2005-04-24T15:56:00</td><td></td></tr>
    <tr><td>56</td><td>465</td><td>2013-09-11T10:05:22</td><td>Lorem ipsum dolor</td></tr>
    <tr><td>57</td><td>133</td><td>2007-12-22T14:30:15</td><td>convallis, dolor lectus laoreet</td></tr>
    <tr><td>58</td><td>357</td><td>2005-04-17T09:11:31</td><td>amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel</td></tr>
    <tr><td>59</td><td>169</td><td>2009-09-08T06:37:12</td><td>Sed ullamcorper, lorem vel feugiat convallis, dolor</td></tr>
    <tr><td>60</td><td>488</td><td>2006-04-09T23:13:49</td><td>consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis,</td></tr>
    <tr><td>61</td><td>682</td><td>2005-11-30T13:54:47</td><td>laoreet sapien, eu porta</td></tr>
    <tr><td>62</td><td>498</td><td>2006-09-20T10:32:20</td><td>adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor</td></tr>
    <tr><td>63</td><td>113</td><td>2010-07-15T14:02:04</td><td></td></tr>
    <tr><td>64</td><td>578</td><td>2009-10-20T05:49:19</td><td>Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu porta</td></tr>
    <tr><td>65</td><td>327</td><td>2009-05-06T17:30:12</td><td>sit amet,</td></tr>
    <tr><td>66</td><td>49</td><td>2005-04-11T03:59:41</td><td>amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu</td></tr>
    <tr><td>67</td><td>291</td><td>2014-05-07T12:42:46</td><td>ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet</td></tr>
    <tr><td>68</td><td>992</td><td>2009-12-05T08:37:55</td><td>laoreet sapien, eu porta</td></tr>
    <tr><td>69</td><td>144</td><td>2008-10-13T14:15:57</td><td></td></tr>
    <tr><td>70</td><td>623</td><td>2015-04-02T02:18:07</td><td>amet, consectetuer adipiscing elit. Sed ullamcorper, lorem</td></tr>
    <tr><td>71</td><td>5</td><td>2008-08-07T15:48:12</td><td></td></tr>
    <tr><td>72</td><td>239</td><td>2009-07-21T04:22:05</td><td>convallis, dolor lectus laoreet</td></tr>
    <tr><td>73</td><td>412</td><td>2008-05-03T16:16:05</td><td>Sed ullamcorper, lorem vel feugiat convallis, dolor</td></tr>
    <tr><td>74</td><td>232</td><td>2006-01-04T21:41:41</td><td>consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu</td></tr>
    <tr><td>75</td><td>84</td><td>2005-08-10T19:12:54</td><td>ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu porta</td></tr>
    <tr><td>76</td><td>935</td><td>2006-08-28T14:54:34</td><td>dolor sit amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu porta</td></tr>
    <tr><td>77</td><td>89</td><td>2009-09-27T11:14:37</td><td>lectus</td></tr>
    <tr><td>78</td><td>915</td><td>2005-05-06T08:42:05</td><td>ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet</td></tr>
    <tr><td>79</td><td>531</td><td>2014-02-13T22:14:12</td><td>amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor</td></tr>
    <tr><td>80</td><td>791</td><td>2006-02-01T05:15:07</td><td></td></tr>
    <tr><td>81</td><td>472</td><td>2006-09-10T17:00:38</td><td>adipiscing elit. Sed</td></tr>
    <tr><td>82</td><td>891</td><td>2006-02-13T21:27:04</td><td>consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu</td></tr>
    <tr><td>83</td><td>32</td><td>2015-08-18T12:06:01</td><td>convallis, dolor lectus laoreet</td></tr>
    <tr><td>84</td><td>935</td><td>2013-01-15T15:47:13</td><td>sit amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel</td></tr>
    <tr><td>85</td><td>140</td><td>2008-11-01T04:06:55</td><td>feugiat convallis, dolor lectus laoreet sapien, eu porta</td></tr>
    <tr><td>86</td><td>223</td><td>2006-03-27T04:17:33</td><td>laoreet sapien,</td></tr>
    <tr><td>87</td><td>778</td><td>2007-03-22T05:02:19</td><td>lorem vel</td></tr>
    <tr><td>88</td><td>880</td><td>2008-02-06T07:28:55</td><td>lorem vel feugiat convallis, dolor lectus laoreet sapien,</td></tr>
    <tr><td>89</td><td>755</td><td>2009-03-13T00:52:29</td><td>vel feugiat convallis, dolor lectus laoreet sapien,</td></tr>
    <tr><td>90</td><td>537</td><td>2015-04-23T00:48:39</td><td>feugiat convallis, dolor lectus laoreet</td></tr>
    <tr><td>91</td><td>24</td><td>2008-07-23T00:34:41</td><td>ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet</td></tr>
    <tr><td>92</td><td>74</td><td>2011-12-03T23:38:09</td><td>adipiscing</td></tr>
    <tr><td>93</td><td>721</td><td>2014-09-24T07:01:48</td><td>laoreet sapien, eu</td></tr>
    <tr><td>94</td><td>777</td><td>2013-11-14T22:41:08</td><td>ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu</td></tr>
    <tr><td>95</td><td>602</td><td>2009-06-19T09:18:18</td><td>elit. Sed ullamcorper, lorem vel feugiat convallis, dolor</td></tr>
    <tr><td>96</td><td>712</td><td>2007-10-02T16:15:26</td><td></td></tr>
    <tr><td>97</td><td>258</td><td>2008-08-10T08:48:26</td><td>dolor sit amet, consectetuer adipiscing elit. Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet sapien, eu</td></tr>
    <tr><td>98</td><td>404</td><td>2014-08-28T11:54:27</td><td></td></tr>
    <tr><td>99</td><td>210</td><td>2015-04-19T20:00:47</td><td>Sed ullamcorper, lorem vel feugiat convallis, dolor lectus laoreet</td></tr>
    <tr><td>100</td><td>840</td><td>2007-06-23T19:22:14</td><td></td></tr>
</table>