topic Re: Field_Comments in QlikView

Field_Comments

Tue, 19 Mar 2013 06:39:12 GMT

I am having a field 'name' and i am taking it form .csv file format. In that file 'name' field is stored as '//name' i.e. with comment. Now when i load table in qlikview it is loaded with the field commented.

Can anyone tell how to load the field without comment marks. I am working in QV10 version.

Re: Field_Comments

sushil353 — Tue, 19 Mar 2013 06:49:32 GMT

try this:

mid('//name',3 )

Re: Field_Comments

sushil353 — Tue, 19 Mar 2013 06:51:50 GMT

if you have '//' in the other position too..

Then try

purgechar ( '//name','//' )

Re: Field_Comments

Tue, 19 Mar 2013 07:24:10 GMT

here is the issue that when i pick up the table from csv it picks the name field as '//name'. Due to this it takes the name field commented.

Re: Field_Comments

kaushiknsolanki — Tue, 19 Mar 2013 07:28:50 GMT

Hi,

I would suggest you to go to CSV and change there only.

I had thought of Rename field function but that will also not work in your case.

Regards,

Kaushik Solanki

Re: Field_Comments

Tue, 19 Mar 2013 07:31:03 GMT

Your suggestion is Right. Same thing I told to my client. But they refused to change anything in the file.

Please provide any other solution.

Re: Field_Comments

er_mohit — Tue, 19 Mar 2013 07:37:20 GMT

try this

when you load your field from csv then it is//

when load it in script to perform task then use use that field name in square bracket like this

[//name]. it works fine

Re: Field_Comments

kaushiknsolanki — Tue, 19 Mar 2013 07:57:46 GMT

Hi,

I agree with Mohit.

This works fine.

Regards,

Kaushik Solanki

Re: Field_Comments

Tue, 19 Mar 2013 16:28:24 GMT

Thnx 2 all