i have a database SQL with a table with two fields (Code - char 20 / Description - char 40). Sometimes the Code field is populated not from column 1 (see examples) and when i LOAD the Code field in Qlikview the initial spaces are left out.
Example column CODE Load in Qlikview
001 002 01 001 002 01
001 02004 001 02004
002 01 002 01
I would like the LOAD command to respect the data of the database:
So, are these columns (Article, model, etc.) are all concatenated in one field in the database? Looks really strange, but still shouldn't be a big deal, if you know exactly the order and length of the parts. You can use len() and mid() functions in this case to cut it in the correct pieces.
the questions "why" don't have technical answers... Qlikview, like Excel, "assumes" that if all characters are numbers, the whole data piece is numeric. Both cut off the lesding spaces and 0's. So, we have to use some additional measures if it it's not a number...