Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
so i have a data , lets say
Project Sprint
A Sprint 1 , Sprint 2 , Sprint 3
B
C Sprint 1 , Sprint 2
D Sprint 1 , Sprint 2, Sprint 3 , Sprint 4
so i try to load
Subfield("Sprint",",",1) as first start sprint
Subfield("Sprint",",",-1) as end sprint time
it appear perfectly , but the data with null sprint value will appear as " - " both in first and end sprint..
Result (not what i want)
Proj first sprint end sprint
A sprint 1 sprint 3
B - - (this should be not appear)
C sprint 1 sprint 2
D sprint 1 sprint 3
i already try with wildmatch("Sprint", '-')=0 , not wild match("Sprint",'-') , i count the len("Sprint")>1 , and it still appear the project with anonymous first and end sprint known as '-', is there anything wrong ?
Put condition
where(len(trim(Sprint))>0