topic Re: How to load from variable/dynamic datasources in QlikView https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669851#M243411 <HTML><HEAD></HEAD><BODY><P>I think you've marked correct yourself, which I suppose to get it.</P></BODY></HTML> Tue, 07 Oct 2014 09:50:55 GMT senpradip007 2014-10-07T09:50:55Z How to load from variable/dynamic datasources https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669846#M243406 <HTML><HEAD></HEAD><BODY><P>Hello guys,</P><P></P><P>I would like to use variable datasources in a text object to switch from <STRONG>live</STRONG> to <STRONG>stage</STRONG> when reloading data.</P><P></P><P>The application uses relative paths to load data from two folders:</P><P></P><P>[...]\live\</P><P>[...]\stage\</P><P></P><P>The subfolders and files are the same in each of the above folders.</P><P></P><P>Could you please advice on how to do this? Many thanks for your support</P><P></P><P>Regards, Andrea</P></BODY></HTML> Tue, 07 Oct 2014 08:35:25 GMT https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669846#M243406 iamthefixer 2014-10-07T08:35:25Z Re: How to load from variable/dynamic datasources https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669847#M243407 <HTML><HEAD></HEAD><BODY><P>Create a variable vDataSourc = 'live' and then use like [....]\$(vDataSourc)\</P></BODY></HTML> Tue, 07 Oct 2014 08:41:27 GMT https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669847#M243407 senpradip007 2014-10-07T08:41:27Z Re: How to load from variable/dynamic datasources https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669848#M243408 <HTML><HEAD></HEAD><BODY><P>You can use TableName() or FileBaseName() function for identify the file name from folders.</P></BODY></HTML> Tue, 07 Oct 2014 08:44:29 GMT https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669848#M243408 its_anandrjs 2014-10-07T08:44:29Z Re: How to load from variable/dynamic datasources https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669849#M243409 <HTML><HEAD></HEAD><BODY><P>Pradip, thank you. It worked like a charm.</P><P></P><P>Andrea</P></BODY></HTML> Tue, 07 Oct 2014 09:42:06 GMT https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669849#M243409 iamthefixer 2014-10-07T09:42:06Z Re: How to load from variable/dynamic datasources https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669850#M243410 <HTML><HEAD></HEAD><BODY><P>Anand, thank you. I am not familiar with TableName() or FileBaseName() but I will explore the option as I see value in your solution.</P><P>Thank you</P><P>Andrea</P></BODY></HTML> Tue, 07 Oct 2014 09:47:06 GMT https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669850#M243410 iamthefixer 2014-10-07T09:47:06Z Re: How to load from variable/dynamic datasources https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669851#M243411 <HTML><HEAD></HEAD><BODY><P>I think you've marked correct yourself, which I suppose to get it.</P></BODY></HTML> Tue, 07 Oct 2014 09:50:55 GMT https://community.qlik.com/t5/QlikView/How-to-load-from-variable-dynamic-datasources/m-p/669851#M243411 senpradip007 2014-10-07T09:50:55Z