Wildcards metadata label for a field in Table Viewer

[SPrabhu]

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?

Thanks!

[jonathandienst]

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?

[jonathandienst]

No mention of it in the Help either:

Table Viewer

[SPrabhu]

Yep, I understand. Here you go...



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

[Brett_Bleess]

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

[hic]

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

[hic]

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

HIC