Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem in QlikView in connection with submission of an alphanumeric key field. The client wants the number to appear as the database.
Example: COD_CLI = 01855 and 0001855 (SQL Server).
For QlikView, this is only one number: 01855. Has anyone experienced a similar situation?
Thanks.
Marcia.
Use Text(FieldName) which converts it as string
You will need to wrap COD_CLI as text(COD_CLI) in the script itself so that QV interprets it as a string and retains both variants 01855 and 0001855.
I'm hoping you mentioned Text(COD_CLI) as [COD CLI] in the load script because the load will fail if you just wrote Text(COD_CLI)
Ok, thanks for your help.