This script is not working LOAD * FROM [https://api.telegram.org/bot1386460209:AAHj0iG8F8ibZBpMYglkC

sashazhk — Fri, 28 Aug 2020 08:25:39 GMT

This script is not working LOAD * FROM [https://api.telegram.org/bot1386460209:AAHj0iG8F8ibZBpMYglkCy2VWtM-gaV-AF4/sendMessage?chat_id=-1001373057355&text=Qlik View data is successfully updated!] (txt, codepage is 1251, no labels, delimiter is ';', msq); Error: File not found error Cannot open file: 'https://api.telegram.org/bot1386460209:AAHj0iG8F8ibZBpMYglkCy2VWtM-gaV-AF4/sendMessage?chat_id=-1001373057355&text=Qlik View data is successfully updated!' LOAD * FROM [https://api.telegram.org/bot1386460209:AAHj0iG8F8ibZBpMYglkCy2VWtM-gaV-AF4/sendMessage?chat_id=-1001373057355&text=Qlik View data is successfully updated!] (txt, codepage is 1251, no labels, delimiter is ';', msq) On other computers it works

Re: This script is not working LOAD * FROM [https://api.telegram.org/bot1386460209:AAHj0iG8F8ibZBpMY

Brett_Bleess — Wed, 09 Sep 2020 14:33:47 GMT

I would venture the issue is the delimiter in your case, there are no ';'s in the result from my own checking of things. It would appear to be either comma or colon is the delimiter, and I tested with comma, and things did parse etc. Everything ran just fine for me using 12.50 SR1 Desktop client, here is the script:

LOAD @1,
@2,
@3,
@4,
@5,
@6,
@7
FROM
[https://api.telegram.org/bot1386460209:AAHj0iG8F8ibZBpMYglkCy2VWtM-gaV-AF4/sendMessage?chat_id=-1001373057355&text=Qlik]
(txt, codepage is 28591, no labels, delimiter is ',', msq);

Regards,
Brett

topic This script is not working LOAD * FROM [https://api.telegram.org/bot1386460209:AAHj0iG8F8ibZBpMYglkC in QlikView

This script is not working LOAD * FROM [https://api.telegram.org/bot1386460209:AAHj0iG8F8ibZBpMYglkC

Re: This script is not working LOAD * FROM [https://api.telegram.org/bot1386460209:AAHj0iG8F8ibZBpMY