Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

Table Field with Strange Character

Hi,


I'm saving a file in txt format, but when a load this file, the field name is broke. I think that have some relation with UTF-8 encode, but I don't know how to store properly this

 

If($(vError_code)<>0) then

  Let MyMessage ='$(vDetail)';

  Log:
  LOAD
  '$(vApp_Id)' 		as [App_Name]
  ,'$(vStep)' 		as [Step]
  ,'$(MyMessage)' 	as [Message]
  AutoGenerate 1;

  STORE Log INTO [lib://Dados/LightP&D/cas_br_cuc/Log/Log_$(vDataCarga).txt](txt);

  Drop Table Log;

Load * from [lib://Dados/LightP&D/cas_br_cuc/Log/Log_$(vDataCarga).txt](txt);

 

 

image.png

 

PS: I read about and I believe that my problem is the BOM, but still don't know how to remove that

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Re: Table Field with Strange Character

Finally I found a way. I 'll keep this post if someone have the same problem that I.

LOAD
App_Name,
"Step",
Message
FROM [lib://Dados/Light P&D/cas_br_cuc/Log/Log_20191210.csv]
(txt, utf8, embedded labels, delimiter is ',', no quotes);

View solution in original post

2 Replies
Highlighted
Specialist II
Specialist II

Re: Table Field with Strange Character

I create a workround, save in a qvd and not a csv, but I'll still looking for an answer.

Highlighted
Specialist II
Specialist II

Re: Table Field with Strange Character

Finally I found a way. I 'll keep this post if someone have the same problem that I.

LOAD
App_Name,
"Step",
Message
FROM [lib://Dados/Light P&D/cas_br_cuc/Log/Log_20191210.csv]
(txt, utf8, embedded labels, delimiter is ',', no quotes);

View solution in original post