topic Re: Left Function Issue in QlikView

Left Function Issue

alec1982 — Wed, 27 Nov 2013 19:28:11 GMT

Hi Guys,

I run into an issue when using Left function.

When I apply it on Local QlikView platform it works as needed but when I try to load the script on the server it doesn't recognize the Left function and it returns Null Value..

Both my local machine and server are on V11

Any thoughts?

Thxs,

Alec

Re: Left Function Issue

Clever_Anjos — Wed, 27 Nov 2013 19:38:02 GMT

Please post part of your script here

Re: Left Function Issue

alec1982 — Wed, 27 Nov 2013 19:44:18 GMT

Hi,

The table on the source looks like

1/2011

1/2012

2/2012

3/2012

Table1:

Load ows_LinkTitle,

Left([ows_LinkTitle],1) as [Key]

From Source table

It works on my local QV normally but not on the server..

Thxs,

Alec

Re: Left Function Issue

Clever_Anjos — Wed, 27 Nov 2013 19:47:06 GMT

First let´s put some 'silly' test

Table1:

Load ows_LinkTitle,

Left([ows_LinkTitle],1) as [Key],

Left('ABC',1) as ShouldBeA

From Source table

Re: Left Function Issue

jpapador — Wed, 27 Nov 2013 19:49:30 GMT

Are you connecting to the same data source in both cases?

Re: Left Function Issue

alec1982 — Wed, 27 Nov 2013 19:55:07 GMT

Hi,

Yes I am connecting to the same source.

I have tested differently and used Left(FieldName, 2) and worked.

I am not sure why the server adds an additional character while my PC read the right value..

Note: I am loading data from SharePoint XML List.

Please let me know your thoughts..

Thxs,

Alec

Re: Left Function Issue

Clever_Anjos — Wed, 27 Nov 2013 19:56:43 GMT

Try

Left(trim([ows_LinkTitle]),1) as [Key],

Re: Left Function Issue

alec1982 — Wed, 27 Nov 2013 20:18:58 GMT

all of these functions work but I am trying to find why my pc loads the correct value while the server adds on one more chr to it.

Re: Left Function Issue

Clever_Anjos — Wed, 27 Nov 2013 21:29:52 GMT

Its exactly the same version?

Re: Left Function Issue

Clever_Anjos — Wed, 27 Nov 2013 21:36:14 GMT

Are you extracting through an ODBC/OLEDB driver? Maybe some different configuration