Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
lucascerq
Contributor II
Contributor II
‎2019-03-04 02:18 PM

Números escritos com caracteres especiais, fonte XML

Prezados,

Estou importando uma tabela de origem XML, e no campo ORG que deve exibir números apenas, está aparecendo caracteres especiais, não vinculando aos números correspondentes...

Como devo proceder para que o qlikview leia os números corretamente? Capturar Qlik.PNG

434 Views
0 Likes
1 Reply
lfetensini
Partner - Creator II
Partner - Creator II
‎2019-04-24 09:56 PM

Utilize a função de manter somente os caracteres que você deseja de um campo. Se for somente os números, fica assim:

KeepChar(Org, '0123456789') as Org
Support your colleagues. Remember to "like" the answers that are helpful to you and flag as "solved" the one that helped you solve. Cheers.
400 Views
0 Likes