topic Re: Metadata handling not working properly in QlikView

Metadata handling not working properly

Siva_Sankar — Wed, 06 Jan 2016 06:44:54 GMT

Hi,

I have gone through Handling Metadata in QlikView by sinanozdemir and when I try to implement it ,it works for some tables and not for some.

I have attached a application.

Can any one look and see and let me know why is it?

Regards,

Sivasankar

Re: Metadata handling not working properly

Kushal_Chawda — Wed, 06 Jan 2016 07:02:55 GMT

Please check the attached.

I think order of loading table should be the same as in inline table.

Re: Metadata handling not working properly

jagan — Wed, 06 Jan 2016 07:24:18 GMT

Hi,

In QV 11.2 SR9 it is not working as expected even changing the order.

Regards,

Jagan.

Re: Metadata handling not working properly

Kushal_Chawda — Wed, 06 Jan 2016 07:29:42 GMT

I am using 11.2 SR12 and it is working for me

Re: Metadata handling not working properly

jagan — Wed, 06 Jan 2016 07:29:49 GMT

Even the alternate method is also not working for ASCII and Transactions tables

Comment Table Characters with 'Contains Characters';

Comment Table ASCII with 'Contains ASCII Values';

Comment Table Transactions with 'Contains Transaction Facts';

Comment Table Dummy with 'dummies values';

Re: Metadata handling not working properly

Kushal_Chawda — Wed, 06 Jan 2016 07:30:54 GMT

Have you tried opening the QVW which I have attached?

Re: Metadata handling not working properly

tamilarasu — Wed, 06 Jan 2016 07:42:48 GMT

I guess the problem must be in the below statement in the Characters table.

Load Chr(RecNo()+Ord('A')-1) as Alpha, RecNo() as Num autogenerate 26;

If you change the Alpha to some other name then it's working fine.

Check the attachment.

Re: Metadata handling not working properly

maxgro — Wed, 06 Jan 2016 07:48:45 GMT

It seems the Characters table, when i change the load script of that table, it starts working; see attachment

Re: Metadata handling not working properly

Siva_Sankar — Wed, 06 Jan 2016 07:55:09 GMT

Its not working in my existing dashboard even after changing the order and other suggestions.

Version I am using Qv 11 SR 12

Re: Metadata handling not working properly

tamilarasu — Wed, 06 Jan 2016 07:58:07 GMT

Did you check the attachment.?

Re: Metadata handling not working properly

Siva_Sankar — Wed, 06 Jan 2016 08:04:31 GMT

Tamil Nagaraj,

That is the issue. Why should I break the link between the tables? What is the logic behind comments?

What is the limitation of using comments?

Regards,

Siva Sankar

Re: Metadata handling not working properly

tamilarasu — Wed, 06 Jan 2016 08:18:33 GMT

Hi Shankar,

I am not sure about the limitation. If you move the character table script below ASCII table or somewhere, the comments are displayed correctly. I am not sure why the Character table is causing the problem. Maybe someone might have answer for this.

Check the below attachment.

Re: Metadata handling not working properly

Siva_Sankar — Wed, 06 Jan 2016 08:37:28 GMT

Find the attachment, I have included one more table. now the comments are gone again.

Re: Metadata handling not working properly

Kushal_Chawda — Wed, 06 Jan 2016 08:56:06 GMT

This script is working fine for me & I can see the comments

QV version - 11.2 SR12

[Table map]:

Mapping LOAD * INLINE

[

Table,Description

ASCII, Contains ASCII Values

Characters, Contains Characters

Transactions, Contains Transaction Facts

Dummy, dummies values

];

ASCII:

Load

if(RecNo()>=65 and RecNo()<=90,RecNo()-64) as Num,

Chr(RecNo()) as AsciiAlpha,

RecNo() as AsciiNum

autogenerate 255

Where (RecNo()>=32 and RecNo()<=126) or RecNo()>=160 ;

Characters:

Load Chr(RecNo()+Ord('A')-1) as Alpha, RecNo() as Num autogenerate 26;

Transactions:

Load

TransLineID,

TransID,

mod(TransID,26)+1 as Num,

Pick(Ceil(3*Rand1),'A','B','C') as Dim1,

Pick(Ceil(6*Rand1),'a','b','c','d','e','f') as Dim2,

Pick(Ceil(3*Rand()),'X','Y','Z') as Dim3,

Round(1000*Rand()*Rand()*Rand1) as Expression1,

Round( 10*Rand()*Rand()*Rand1) as Expression2,

Round(Rand()*Rand1,0.00001) as Expression3;

Load

Rand() as Rand1,

IterNo() as TransLineID,

RecNo() as TransID

Autogenerate 1000

While Rand()<=0.5 or IterNo()=1;

Dummy:

Load * inline

[

Alpha,numbercol

sadsad,123123123

qewqeqwe,123123123

];

Comment Tables using [Table map];

Re: Metadata handling not working properly

Siva_Sankar — Wed, 06 Jan 2016 09:45:49 GMT

What changes you have to do with actual scrip to make the comments appear?

Re: Metadata handling not working properly

tamilarasu — Wed, 06 Jan 2016 10:10:12 GMT

I did some tests but no luck. If I add one more table, it's not showing the comments for one table.

Re: Metadata handling not working properly

Kushal_Chawda — Wed, 06 Jan 2016 10:28:00 GMT

I have not done any changes just did ordering as per the inline table. I added one more table Test in inline & in actual load and I can see the comments

Re: Metadata handling not working properly

Siva_Sankar — Wed, 06 Jan 2016 10:35:08 GMT

I tried using the same ordering with an additional table. Not working as expected.

Table_map:
Mapping LOAD * INLINE
[
Table,Description
ASCII, Contains ASCII Values
Transactions, Contains Transaction Facts
Dummy, dummies values
Test3,Transactional datas
Characters, Contains Characters
];

[ASCII]:
Load
if(RecNo()>=65 and RecNo()<=90,RecNo()-64) as Num,
Chr(RecNo()) as AsciiAlpha,
RecNo() as AsciiNum
autogenerate 255
Where (RecNo()>=32 and RecNo()<=126) or RecNo()>=160 ;

Transactions:
Load
TransLineID,
TransID,
mod(TransID,26)+1 as Num,
Pick(Ceil(3*Rand1),'A','B','C') as Dim1,
Pick(Ceil(6*Rand1),'a','b','c','d','e','f') as Dim2,
Pick(Ceil(3*Rand()),'X','Y','Z') as Dim3,
Round(1000*Rand()*Rand()*Rand1) as Expression1,
Round( 10*Rand()*Rand()*Rand1) as Expression2,
Round(Rand()*Rand1,0.00001) as Expression3;
Load
Rand() as Rand1,
IterNo() as TransLineID,
RecNo() as TransID
Autogenerate 1000
While Rand()<=0.5 or IterNo()=1;

Dummy:
Load * inline
[
Alpha,numbercol
sadsad,123123123
qewqeqwe,123123123
];

Test3:
Load * inline
[
TransID,Data
1123,40000
1223,20000
];

Characters:
Load Chr(RecNo()+Ord('A')-1) as Alpha, RecNo() as Num autogenerate 26;

Comment Tables using Table_map;

Regards,

Siva Sankar

Re: Metadata handling not working properly

Kushal_Chawda — Wed, 06 Jan 2016 11:17:22 GMT

I think there is a bug with comment statement

because normal comment statement also not working as below

Comment Table Test3 with 'Test 3 table'

Re: Metadata handling not working properly

sinanozdemir — Wed, 06 Jan 2016 14:14:25 GMT

Put Dummy and Test3 tables after Characters table:

The problem seems to be with Characters table and I cannot exactly say why.