Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
can u please help me with the below requirement
i have table like below
flag | cc | total |
same | 2 | |
b | same | 3 |
f | same | 4 |
b | notsame | 4 |
f | notsame | 5 |
i have to ignore records where (flag =b and cc = same) and where (flag =f and cc =same)
output:
flag | cc | total |
same | 2 | |
b | notsame | 4 |
f | notsame | 5 |
Thanks in advance
Regards
siva
in script
load *
where not (flag='b' and cc='same') and not (flag='f' and cc='same')
;
load * inline [
flag,cc,total
,same,2
b,same,3
f,same,4
b,notsame,4
f,notsame,5
];
on chart 2 options.
1-set analysis - something like below the - eliminates the combiantions
=Only(
{
-<flag={'b'},cc={'same'}>
-<flag={'f'},cc={'same'}>
}
total)
2-If statement - create a dimension like below and suppress when value is null
=if((flag='b' and cc='same')or (flag='f' and cc='same'),null(),flag)
do you need to do it on the table or script?
Hi Dilipranjith,
in script while loading the table i have to ignore records based on above mentioned where clause
thanks
siva
in script
load *
where not (flag='b' and cc='same') and not (flag='f' and cc='same')
;
load * inline [
flag,cc,total
,same,2
b,same,3
f,same,4
b,notsame,4
f,notsame,5
];
on chart 2 options.
1-set analysis - something like below the - eliminates the combiantions
=Only(
{
-<flag={'b'},cc={'same'}>
-<flag={'f'},cc={'same'}>
}
total)
2-If statement - create a dimension like below and suppress when value is null
=if((flag='b' and cc='same')or (flag='f' and cc='same'),null(),flag)