Left Function Issue

[alec1982]

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

[Clever_Anjos]

Please post part of your script here

[alec1982]

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

[Clever_Anjos]

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

[jpapador]

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

[alec1982]

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

[Clever_Anjos]

Try

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

[alec1982]

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.

[Clever_Anjos]

Its exactly the same version?

[Clever_Anjos]

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