topic Re: variable in from in QlikView

variable in from

gr_eldred — Sat, 16 Nov 2024 00:42:54 GMT

good afternoon i need help with a script.

I have to use a variable inside a from in a FOR loop.

SET vFamilias = 'luis.castro%40multimedios.com';
for each q in $(vFamilias)

MailChimpConnectorV2_MemberInfo:
LOAD
id as MemberInfo_id,
email_address as MemberInfo_email_address,
unique_email_id as MemberInfo_unique_email_id,
list_id as MemberInfo_list_id

FROM
"[http://localhost:####/data?...........email="$(q)"&appID=]";

can you help me?

Thanks

Re: variable in from

Taoufiq_Zarra — Fri, 08 May 2020 23:25:49 GMT

Maye be :

FROM "[http://localhost:####/data?...........email=$(q)appID=]";

Re: variable in from

gr_eldred — Fri, 08 May 2020 23:52:29 GMT

I don't work, can't find the file

but the path is correct