Problem with database load

[Anonymous]

Hi

When I load data from an MYSQL database, QlikView adds a zero in the beginning of the value.

Example.

Database

Customer              NationalRegNumber

123                          12345679

QlikView

Customer              NationalRegNumber

123                        012345679

Do some of you have any idea why Qlikview does like this?

Thanks in advance

// Victor

[jonathandienst · Accepted solution]

The first record loaded had a leading 0 in MySQL. QV uses this value to determine the format for the values of that field. If the value is a true number (ie the 0 is not needed), then Num(NationalRegNumber) will force the dropping of the leading 0. If the 0 is significant, then Text(NationalRegNumber) will preserve it in QV.

[Anonymous]

Thank you Jonathan, you saved my day!

Now it works!