topic Hi in QlikView

Hi

Thu, 23 Aug 2012 15:16:27 GMT

Hi, i have creates Table like Table1:select A,b,c from tblfinanc so i want to pull the column A from Table1. i tried select A from Table1 ; but it didn't worked. So how to pull the column from Table1?

Re: Hi

manojkvrajan — Thu, 23 Aug 2012 15:33:57 GMT

SQL statement will not work after you extract the data from your database. Please check if it works.

// Assume Table1 is from your Relational database - Oracle / Mainframe

Table1:

SELECT A,B,C

FROM tblfinanc;

// Assume Table2 is the Resident table that you can use to transform the data

Table2:

LOAD A,

1 as %key

RESIDENT Table1;

DROP TABLE Table1; // Drop Table if it won't be useful.

DROP FIELD %key;

Re: Hi

MayilVahanan — Thu, 23 Aug 2012 16:40:42 GMT

Do you want the A only from table1;

Then why you load all from sql.. Select A from tableName itself enough.. Can you say clearly what your requirement?