topic Re: Composite FROM statement in QlikView

Composite FROM statement

FakeJupiter — Sat, 16 Nov 2024 18:02:41 GMT

Hi!

I'm wondering, is it possible to make a composite FROM statement in script?

For instance, instead of:

FROM [C:/user/QlikView/test.xlsx]

I'd like something like:

FROM 'C:/user/QlikView/' & 'test.xlsx'

Is that in any way possible?

I'm asking, because I want to load specific files by using a variable that defines which files to load.
I understand something like that can be done with a macro, but doing it this way would be far simpler.

Thank you,
Ray

Re: Composite FROM statement

Taoufiq_Zarra — Tue, 29 Sep 2020 10:21:59 GMT

@FakeJupiter

you can use for example :

Set PathFolder='C:\user\QlikView';

then

LOAD * FROM '$(PathFolder)\YOURFILE' ...

Re: Composite FROM statement

FakeJupiter — Tue, 29 Sep 2020 10:27:16 GMT

Thank you for your reply.

I understand that a variable can be used as a prefix, but is it possible to have variable in the middle of the load statement? For instance:

C:/Files/sales & $(salesDate) & .xlsx

Re: Composite FROM statement

Kushal_Chawda — Tue, 29 Sep 2020 10:44:15 GMT

@FakeJupiter Yes, you can use the variable in middle of the path as well like below

FROM C:/Files/sales / $(salesDate).xlsx

FROM 'C:/Files/sales / $(salesDate).xlsx'

FROM [C:/Files/sales / $(salesDate).xlsx]

Re: Composite FROM statement

FakeJupiter — Tue, 29 Sep 2020 12:40:58 GMT

Thanks!