topic Re: Rename a field and Qualify ? in QlikView

Rename a field and Qualify ?

Thu, 08 Oct 2015 10:21:36 GMT

I have three tables and im using qualify on both to rename the fields but unqulaifying one field that which i rename to be the join between all three tables.

The problem is that two tables will join but I cant get the second table's field to rename!! Ive tried rename field To , rename as within the load..

How can I rename the field in the qualify of the second table so that all three tables will join ?

QUALIFY *;

UNQUALIFY fieldname1;

Filteredtable1:

SQL SELECT *,

1 AS countfields

FROM "ABC".dbo."Filteredtable1";

UNQUALIFY *;

QUALIFY *;

UNQUALIFY fieldname2 ;

Filteredtable2:

SQL SELECT *,

1 AS countfields

FROM "ABC".dbo."Filteredtable2";

UNQUALIFY *;

Filteredtable3:

SQL SELECT *,

fieldname3 as fieldname1 , //// JOIN

1 AS countfield

FROM "ABC".dbo."Filteredtable3";

Re: Rename a field and Qualify ?

kristof_j — Thu, 08 Oct 2015 10:26:03 GMT

And have you tried:

rename field ABC to XYZ from Filteredtable2;

Re: Rename a field and Qualify ?

settu_periasamy — Thu, 08 Oct 2015 10:27:28 GMT

Hi,

I think you need to mention the Tablename also.. like

Rename field Filteredtable2.FieldName to FieldName;

Re: Rename a field and Qualify ?

swuehl — Thu, 08 Oct 2015 10:33:57 GMT

Not really sure what you are trying to achieve. Some sample lines of data and expected result may help to understand.

These tables link on fieldname1:

QUALIFY *;

UNQUALIFY fieldname1;

Filteredtable1:

LOAD *, 1 AS countfields INLINE [

fieldname1, fieldname2, fieldname3

1,1,1

];

UNQUALIFY *;

QUALIFY *;

UNQUALIFY fieldname1 ;

Filteredtable2:

LOAD fieldname2 as fieldname1, fieldname3, 1 AS countfields INLINE [

fieldname2, fieldname3

,1,1

];

UNQUALIFY *;

Filteredtable3:

LOAD fieldname2, fieldname3 as fieldname1, 1 AS countfields INLINE [

fieldname2, fieldname3

1,1

];

Re: Rename a field and Qualify ?

Thu, 08 Oct 2015 12:08:08 GMT

yes doesnt seem to rename the field or says the fieldname is already in use.

Re: Rename a field and Qualify ?

Thu, 08 Oct 2015 14:48:57 GMT

swuehl im trying to join three tables loaded via sql and qualify two of the tables apart from the single field from all three that will be the join.

I have to also rename the field though and I can only seem to rename in one of the table loads?

Re: Rename a field and Qualify ?

swuehl — Thu, 08 Oct 2015 15:00:30 GMT

I believe there are limitations on RENAME of / to key fields, because there is more involved than just changing the name. So I think you need to go for AS in table load.

Re: Rename a field and Qualify ?

Thu, 08 Oct 2015 15:18:04 GMT

hello,

that only seems to work in the last table load but its in the second table that i want to rename a field with as but it appears' to do nothing?

Re: Rename a field and Qualify ?

swuehl — Thu, 08 Oct 2015 15:32:39 GMT

Have you checked my previous post including the script code? I renamed in both table loads a field to fieldname1, thus having all tables linked by fieldname1.

If this does not work for you, please post an potentially executable script (e.g. using INLINE tables like above) that shows your setting.