Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone;
When I load data from SQL to Qlikview doesn't show the information correct in Qlik View for example
if I have a 2 records:
061277
61277
when I load this in qlikview show:
061277
061277
I WAS trying the next and doesn't work:
convert in sql or qlikview to varchar, char, text or money...
also cut characters with function INDEX etc, etc....
CAN YOU HELP PLEASE ANY IDEA?
ACTUALLY Show records in SQL column t_item:
ACTUALLY Show records in QlikView column t_item:
add text
load
text(t_item),
......
;
sql select
t_item
.....
;
Hi, try converting the field to text in QlikView. Also you can concatenate some "dummy symbol/letter" which can later be deleted:
'_' & text(your_field) as your_field
regards
Doesn't work to convert to TEXT
your way work it BUT we have maannyyy aplications for example if I need to make an JOIN with two tables then I need to do for fact table the same put '_' & text(your_field) as your_field and I am taking just tow tables...and we have manyyyy tables with joins but thanks for your idea....
Some other idea?
try converting to text and also concatenating a null character:
chr(0) & text(your_field) as your_field)
strange as I use it in a lot of load script for the same reason
is it the first load of t_item field?
Hi Omar,
Your SQL result shows two records with the codes 061277 and 61277 and both records in the qlikview table have 61278 as t_item. They are not the same. Maybe you selected the wrong records in the qlikview app.
Is t_item unique in your database, since you have differnt t_dsca for the same t_item?
Eduardo
Hi,
Eduardo is right, in the first picture the t_item that appear are:
then in the second screenshot the t_item is 61278. Even descriptions for those items are different.
Could you please confirm that converting to text is not working for you?
regards