topic Set v_Concatenate =''; For each SheetName in 'DEP13','DEP09','DEP04','DEP01','DEP11','DEP06','DEP08','DEP02','DEP03','DEP07','DEP12','DEP16' $(v_Concatenate) US_MIS: LOAD* FROM [\\C.Avnish\US_MIS_2017_2100.xlsx] (ooxml, em in QlikView https://community.qlik.com/t5/QlikView/Set-v-Concatenate-For-each-SheetName-in-DEP13-DEP09-DEP04-DEP01/m-p/6437#M792604 <HTML><HEAD></HEAD><BODY><P>Can some one explain the code?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT avnish319 2020-11-25T16:16:04Z Set v_Concatenate =''; For each SheetName in 'DEP13','DEP09','DEP04','DEP01','DEP11','DEP06','DEP08','DEP02','DEP03','DEP07','DEP12','DEP16' $(v_Concatenate) US_MIS: LOAD* FROM [\\C.Avnish\US_MIS_2017_2100.xlsx] (ooxml, em https://community.qlik.com/t5/QlikView/Set-v-Concatenate-For-each-SheetName-in-DEP13-DEP09-DEP04-DEP01/m-p/6437#M792604 <HTML><HEAD></HEAD><BODY><P>Can some one explain the code?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-v-Concatenate-For-each-SheetName-in-DEP13-DEP09-DEP04-DEP01/m-p/6437#M792604 avnish319 2020-11-25T16:16:04Z Re: Set v_Concatenate =''; For each SheetName in 'DEP13','DEP09','DEP04','DEP01','DEP11','DEP06','DEP08','DEP02','DEP03','DEP07','DEP12','DEP16' $(v_Concatenate) US_MIS: LOAD* FROM [\\C.Avnish\US_MIS_2017_2100.xlsx] (ooxml, em https://community.qlik.com/t5/QlikView/Set-v-Concatenate-For-each-SheetName-in-DEP13-DEP09-DEP04-DEP01/m-p/6438#M792605 <HTML><HEAD></HEAD><BODY><P>Try to create issue title as much short and create body message as much you want.</P><P></P><P>Niw, there is nothing i believe</P><P></P><P>Created two variable which one for directory and another one for all statuc names into one for future</P></BODY></HTML> Thu, 25 Jan 2018 00:46:40 GMT https://community.qlik.com/t5/QlikView/Set-v-Concatenate-For-each-SheetName-in-DEP13-DEP09-DEP04-DEP01/m-p/6438#M792605 Anil_Babu_Samineni 2018-01-25T00:46:40Z