Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have filed values like below. I want to display string like 'Snapshot' values from Starting or Ending with Snapshot?
EBS:VolumeUsage
USW2-EBS:SnapshotUsage
EBS:SnapshotUsage
Thanks,
Siva
if(index(YourField,'Snapshot')>0,'Snapshot',YourField) as YourNewField;
Hi MW,
It doesn't filtering any data with above expression
Thanks,
Siva
try this
script:
A:
load Test,
if(Test like '*Snapshot*', 1,0) as MyData;
load * Inline [
Test
EBS:VolumeUsage
USW2-EBS:SnapshotUsage
EBS:SnapshotUsage];
Front end:
strighttable:
Dim:Test
Exp: count({<MyData={1}>}Test) for snapshot values result
count({<MyData={0}>}Test) for non snapshot values result