Duplicate records ?

[#1]

I have a datasource with a Customers table (Code, Description):

1, Customer1

2, Customer2

3, Customer3

001, Customer4

4, Customer5

After loading all related data of Customer1 and Customer4 are summed.

Is it possible to cast the field as a string when loading the data into QlikView?

[jvitantonio · Accepted solution]

use text(Code) when loading your data

[swuehl]

try using

LOAD

text(Code) as Code,

Description

from...