https://community.qlik.com/t5/QlikView/qlikview-load-data-from-multiple-excel-to-a-given-date/m-p/2035755#M1222528 <PRE class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">I want to load excel data from date 20221009 to 20230130.<BR /></SPAN></PRE> <PRE class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">Dates 20221009 to 20230130 use Sheet1 but from 20230201 use Sheet 2.<BR />Dates 20221009 to 20230130 use Sheet1, but from 20230201 onwards use Sheet 2.<BR /></SPAN></PRE> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">with Sheet 1 still in place.</SPAN></PRE> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">&nbsp;</SPAN></PRE> <P>I use Code&nbsp;&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Suchanan_0-1675925177384.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/100012i1E8CB1CE3B7072DD/image-size/medium?v=v2&amp;px=400" role="button" title="Suchanan_0-1675925177384.png" alt="Suchanan_0-1675925177384.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Suchanan_1-1675925462366.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/100013i19C45691FF94A74C/image-size/medium?v=v2&amp;px=400" role="button" title="Suchanan_1-1675925462366.png" alt="Suchanan_1-1675925462366.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 09 Feb 2023 06:52:27 GMT Sxbbb 2023-02-09T06:52:27Z https://community.qlik.com/t5/QlikView/qlikview-load-data-from-multiple-excel-to-a-given-date/m-p/2035755#M1222528 <PRE class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">I want to load excel data from date 20221009 to 20230130.<BR /></SPAN></PRE> <PRE class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">Dates 20221009 to 20230130 use Sheet1 but from 20230201 use Sheet 2.<BR />Dates 20221009 to 20230130 use Sheet1, but from 20230201 onwards use Sheet 2.<BR /></SPAN></PRE> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">with Sheet 1 still in place.</SPAN></PRE> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Translation"><SPAN class="Y2IQFc">&nbsp;</SPAN></PRE> <P>I use Code&nbsp;&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Suchanan_0-1675925177384.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/100012i1E8CB1CE3B7072DD/image-size/medium?v=v2&amp;px=400" role="button" title="Suchanan_0-1675925177384.png" alt="Suchanan_0-1675925177384.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Suchanan_1-1675925462366.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/100013i19C45691FF94A74C/image-size/medium?v=v2&amp;px=400" role="button" title="Suchanan_1-1675925462366.png" alt="Suchanan_1-1675925462366.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 09 Feb 2023 06:52:27 GMT https://community.qlik.com/t5/QlikView/qlikview-load-data-from-multiple-excel-to-a-given-date/m-p/2035755#M1222528 Sxbbb 2023-02-09T06:52:27Z