How to load from variable/dynamic datasources

[iamthefixer]

Hello guys,

I would like to use variable datasources in a text object to switch from live to stage when reloading data.

The application uses relative paths to load data from two folders:

[...]\live\

[...]\stage\

The subfolders and files are the same in each of the above folders.

Could you please advice on how to do this? Many thanks for your support

Regards, Andrea

[senpradip007 · Accepted solution]

Create a variable vDataSourc = 'live' and then use like [....]\$(vDataSourc)\

[its_anandrjs]

You can use TableName() or FileBaseName() function for identify the file name from folders.

[iamthefixer]

Pradip, thank you. It worked like a charm.

Andrea

[iamthefixer]

Anand, thank you. I am not familiar with TableName() or FileBaseName() but I will explore the option as I see value in your solution.

Thank you

Andrea

[senpradip007]

I think you've marked correct yourself, which I suppose to get it.