Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having a new requirement, my data source is .txt files.how can load this files in qlikview.
can anyone helpme with an example.
regards,
baru
Hi Tom,
Thanks for your reply,
i am attaching my file this just sample file of having my data in this format.can you please check..
regads,
baru
Hi baru,
Go to Edit Script->from "Table Files" button you can select the txt file and then reload.
Regards,
Tom
Hi Tom,
Thanks for your reply,
I know this will load the files,but i am getting all the data into one column.this is wrong.
the data is not in proper way in .txt file.How can i consolidate into correct formate in qlikview.
regards,
baru
Hi Baru,
Can you forward a sample text file similar to your file.
Regards,
Tom
Hi, baru
You have to select an appropriate dilimiter symbol and maybe skip some rows as a header.
Look at the attachment.
Hi,
It looks like you will have to choose a custom delimiter symbol, probably #. Try that to se if your data looks ok.
Hi Baru,
Please go through the sample application.
Regards,
Tom
Hi Tom,
thanks for your valuable answers.
I got some idea about loading .txt files,but in my other file when i am giving delimiter is '#' it is dividing into columns but column names is showing @1,etc...
and also when i am giving delimiter is '#',in one column it is showing 'home/shop/familily' how can i eliminate '/' and divide it into ather columns.
please help me.
regards,
baru