Star is * NOT in section access

[markmccoid]

I'm loading a spreadsheet to define "Clusters" which are based on a Product / Type combination, however, some of the combinations that are needed are "anything" for the Type.

For example:

Product | Type | Cluster

P1            | T1       | Cluster1

P1            | *           | CluterOther

So if P1 and T1 then "Cluster1" other wise all other Product P1 combinations with Type will be Cluster Other.

I tried using the Star is *; syntax, but it isn't working as expected.  

Does anyone have any experience with this type of requirement?

[Claudiu_Anghelescu]

* means all the listed values, in your case only T1.

You have to concatenate all the distinct values with the section Access table from which you read the data.

[jonathandienst]

The STAR is * syntax only applies to section access. If you need to do this outside of section access, you will need to transform the data in your load script. There are several possible ways of doing this, for example:

MAP_CLUSTERS:
Mapping LOAD * 
Inline
[
	Type, Cluster
	T1, Cluster1
	
];

LOAD
	....
	Product,
	Type,
	ApplyMap('MAP_CLUSTERS',Type, 'ClusterOther') as Cluster,
	....

[markmccoid]

That was the information I needed.  That it is only applicable in Section Access.  The docs didn't explicitly state this so I wanted to make sure.

Thanks!

[Brett_Bleess]

I believe Claudiu was correct in this case, here is the help, and the reference is Section Access, but I think it should apply outside of Section Access as well, but I had another case recently here on Community where Henric Cronstrom provided some additional info too.  Here is the Help link, which you may have already reviewed:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Scr...

Article links:

https://support.qlik.com/articles/000003749

https://support.qlik.com/articles/000059866

Hopefully those may shed a bit more light on things for you.

Regards,
Brett