Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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.
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
try this:
mid('//name',3 )
if you have '//' in the other position too..
Then try
purgechar ( '//name','//' )
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.
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
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.
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
Hi,
I agree with Mohit.
This works fine.
Regards,
Kaushik Solanki
Thnx 2 all