field Not recognised in Qlikview

[#1]

Hello Guys,

I am confused why it does not work, but when I load the following table from the SQL Databank into Qlikview the category field does not give any fields. I wonder what can be the reason.

SQL Databank view:

Qlikview view:

I tried text(Category) as Category but it does not work. Any Ideas?

Thanks in advance

sravan

[#2]

Hello sravan,

for testing I would take a look at the source and concat the database-column with a leading and trailing char of your choice. Something like this (in the SQL-Statement!): '#' || category || '#' as category. Then reload and see whats happening.

HtH

Roland

[#3]

Hi Roland,

Thanks for your Answer. I did it and gives this result

Products:

LOAD Id,
 Sequence,
 Name,
 Description,
 '#'& Category & '#' as Category,
 GoodProductYN;
SQL SELECT * from Table;

It does not recognise the field and I dont know why?

[Miguel_Angel_Baeyens]

Is that any kind of run-time calculated field (say flowfields in MS Navision, or using some triggers or procedures to get the result) or is a field in a plain table? Is the field called Category? Fields are case sensitive in QlikView, and the same query you do for SQL server may not work in QlikView (as some database field names are case insensitive).

Regards

[#5]

Miguel the field is in a plain table and called Category. It is not calculated as it is just a One character field which mentions which category th product is.For ex:

G for Good

S for Scrap

R for Rework

I am not doing any query. I am just viewing the table in SQL and the view shows as above in the Attached figure before. The same field does not have any input in Qlikview.

The Properties of this field are as follows:

Calculalation( Is Berechnet) is false, only 1 char long etc..

Any help?

[#6]

Hello sravan,

I did NOT mean the load statement. I ment the SQL - Statement. I saw your field in your database is called "ActivityCategory". So replace the "*" in your SQL-Statement with the list of SQL-columns and for the Category code similar: SELECT ... '# ' || ActivityCategory || '# ' as Category FROM Tables. This is oracle SQL-syntax. For SQL-Server it is: SELECT ... '# ' + ActivityCategory + '# ' as Category FROM Tables. Then you can see what the database delievers. To decide, wether the extract is wrong (your database) or the load (QV).

RR

[#7]

Hello Roland,

Can you please write how the Syntax must be. I am getting a syntax error. I tried like this:

LOAD Id,
 Sequence,
 Name,
 Description,
 Category,
 GoodProductYN;
SQL SELECT Id,
 Sequence,
 Name,
 Description,
 GoodProductYN,
 '# ' || ActivityCategory || '# ' as Category
FROM OEE1.dbo."View_Products";

[#8]

when I use only sql script and with out load, I get this script error..

[spividori]

Hello sravan,

Try the following:

LOAD Id,
 Sequence,
 Name,
 Description,
 text(Category) as Category,
 GoodProductYN;
SQL SELECT Id,
 Sequence,
 Name,
 Description,
 GoodProductYN,
 Category
FROM OEE1.dbo."View_Products";

[#10]

Hello Ronald,

This following code I can run

Products:

LOAD Id,
 Sequence,
 Name,
 Description,
 Category,
 GoodProductYN;
SQL SELECT
Id,
Sequence,
Name,
Description,
Category,
GoodProductYN
FROM OEE1.dbo."View_Products";

when I change Category with your code as following I cant run the code.

Products:

LOAD Id,
 Sequence,
 Name,
 Description,
 Category,
 GoodProductYN;
SQL SELECT
Id,
Sequence,
Name,
Description,
//'# ' || Category || '# ' as Category,
GoodProductYN
FROM OEE1.dbo."View_Products";

The Problem I get is like this