Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

how to load.txt files in qlikview?

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

7 Replies
thomas_skariah
Contributor III

Re: how to load.txt files in qlikview?

Hi baru,

Go to Edit Script->from "Table Files" button you can select the txt file and then reload.

Regards,

Tom

Not applicable

Re: how to load.txt files in qlikview?

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

thomas_skariah
Contributor III

Re: how to load.txt files in qlikview?

Hi Baru,

Can you forward a sample text file similar to your file.

Regards,

Tom

whiteline
Honored Contributor II

Re: how to load.txt files in qlikview?

Hi, baru

You have to select an appropriate dilimiter symbol and maybe skip some rows as a header.

Look at the attachment.

morris70
Valued Contributor

Re: how to load.txt files in qlikview?

Hi,

It looks like you will have to choose a custom delimiter symbol, probably #. Try that to se if your data looks ok.

thomas_skariah
Contributor III

Re: how to load.txt files in qlikview?

Hi Baru,

Please go through the sample application.

Regards,

Tom

Not applicable

Re: how to load.txt files in qlikview?

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

Community Browser