Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
SPrabhu
New Contributor

Wildcards metadata label for a field in Table Viewer

Hi There,

Can anybody help me in understanding below one?

"Wildcards" metadata label for a field in Table Viewer

What does it mean? How can I get rid of it?

Untitled.png

Thanks!

 

Labels (2)
6 Replies
MVP
MVP

Re: Wildcards metadata label for a field in Table Viewer

I've never seen that on any QV document I have worked on. What version of QV? Can you paste some more of the table viewer so i can see the message in some context?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Re: Wildcards metadata label for a field in Table Viewer

No mention of it in the Help either:

Table Viewer

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
SPrabhu
New Contributor

Re: Wildcards metadata label for a field in Table Viewer

Yep, I understand. Here you go...



[cid:image001.png@01D4FA7C.21397790]


Support
Support

Re: Wildcards metadata label for a field in Table Viewer

Hey guys, by any chance is that table created in the load script via a wildcard from multiple files?  Hopefully that makes sense, what I mean is something along the lines of Load * from *.csv or something along those lines.  If so, that is the only thing I have run across that might explain it.  I am trying to find some further information, but not sure I will have any luck, but I wanted to see if the above might get us on track.

Regards,
Brett

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

Re: Wildcards metadata label for a field in Table Viewer

This tag appears if you have a field containing a wild card. For instance, if you use the following script

// ================
Star is *;

AB:
Load * Inline
[A, B
a1, b1
all, *];

BC:
Load * Inline
[B, C
b1, c1
b2, c2];
// ================

you will see that the field B gets the wildcard tag.

This is a very old feature, introduced already in QuikView 1, when we couldn't handle NULL values and missing values well. Then we often put such wildcards in the data to be able to handle missing values.

I would recommend not using it today - I am not sure it works completely any longer...

HIC

Highlighted

Re: Wildcards metadata label for a field in Table Viewer

PS. To get rid of it, remove the "Star is *;" from the script.

HIC