Exluding data in script

[stekol61]

Hi!

I'm loading the dimentions below and want to present them in a report/graph.

When I select e.g. Country='S' I want to exclude the Hosts containg 'LAB'.

I also need to have the possibility to see the LAB-Hosts. E.g. by usiga a Dummy 'Country' ='LAB'

Not sure what's the best way to solve this,. In the scipt or in the report

Week	Country	HostName
31	F	PM1
31	F	PM2
31	F	LAB
31	N	PM3
31	N	PM4
31	N	LAB2
31	S	FRE2P
31	S	HY2P
31	S	LAB3P
31	S	LAB4P

[Anonymous]

Hi Stefan,

Can you please try below code in Script editor:

Test 3:

Load Week,

If(WildMatch(HostName,'LAB*','LAB',Country) as Country,

HostName;

Load * Inline

[

Week, Country, HostName

31, F, PM1

31, F, PM2

31, F, LAB

31, N, PM3

31, N, PM4

31,N, LAB2

31, S, FRE2P

31, S, HY2P

31, S, LAB3P

31, S, LAB4P

];

Output :

[Anonymous]

Syntax mistake.. Please find correct one as below:

Test 3:

Load Week,

If(WildMatch(HostName,'LAB*'),'LAB',Country) as Country,

HostName;

Load * Inline

[

Week, Country, HostName

31, F, PM1

31, F, PM2

31, F, LAB

31, N, PM3

31, N, PM4

31,N, LAB2

31, S, FRE2P

31, S, HY2P

31, S, LAB3P

31, S, LAB4P

];

[senpradip007]

Have look at this sample app. Hope it will help.

[bharani8 · Accepted solution]

Here you go..

[stekol61]

Thank you Bharani.

This solved my problem

/Stefan

[bharani8]

Wc! Please mark it as Correct  so it will be useful for others while searching for this

[stekol61]

Done

/Stefan

[bharani8]

Haha.. You hav marked the wrong one as Correct

[stekol61]

Oops.

Should be OK now

[Anonymous]

Hi Stefan,

You have asked for a solution like below:

Hi!

If I select "S" the report should look like this:

Week          Country            HostName

31                    S                    FRE2P

31                    S                    HY2P

If I select the "Dummy" Country 'LAB' I want to see all hosts containg the name 'LAB'

Whare to i use the set modifier in my?expression

But the correct answer you marked doesnt have solution for your second question. Am i right?