Issue in Qlikview new version

[#1]

When I try to load the data from two table

one with ID 024 and other with 24

it give the first appearance of the data i.e. if 024 present in first table it will give 024 and exclude 24 ,if it  is 24 present in first table it give 24 and exclude 024.

Any solution to this , how we get both the data

[rubenmarin]

Hi, load those values using Text():

LOAD Text(ID) as ID

...

[Anonymous]

Well,

May be at UI level it is getting concatenated with your first appeared value.

But queation is: are you getting all the values of 024 and 24 under first appearance of any of them?

[Anonymous]

or try Text() for this field

[#5]

yes

[#6]

it works

[Anonymous]

Good, then you want both?

May be  u r using num() at ETL level?

If you want both the value, then try Text()

[#8]

but prior to this it was working fine

[#9]

what is the reason for this issue

[rubenmarin]

Hi shweta, and it was the same source? something like this can happen when before was readed from a source wich default data type is string (text) but now is reading as default data type as number, and '024' and '24' are the same number.