topic Re: load from internet in QlikView

load from internet

francisvandergr — Thu, 29 Nov 2012 22:00:50 GMT

I wanna load data from internet. the problem is i get one line which i wanna split at every } . How can i do this. I have an attachment.

So every new id must be a new record in qlikview. How can i do this

Re: load from internet

MayilVahanan — Thu, 29 Nov 2012 22:08:24 GMT

PFA

Are you expecting like this..

i can't reload the data. so i test in textbox object. use subfield() for split, if you want to remove []{} braces, use purgechar() .

Want to replace unwanted character, use replace() function

Hope it helps

Re: load from internet

francisvandergr — Thu, 29 Nov 2012 22:22:11 GMT

Sorry this is not what i mean. I have in your way the end of the record. But at that point a new record has to start. So i wanna have 5 records for all 5 id's

First record start with ID 7383

Second record start with 8242

third 7907 etc.

Re: load from internet

MayilVahanan — Thu, 29 Nov 2012 22:34:14 GMT

PFA

Re: load from internet

francisvandergr — Thu, 29 Nov 2012 22:37:15 GMT

thnx