Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my script, I want to have a condition where I keep only certain values. At the end of my script I have FROM [Data Source......] WHERE(team = 'ABC') and (team = 'DEF')......and this repeats eight more times. The script does not function at that point. Is there a more efficient way to do this>?
try use of match
where match(team,'ABC','DEF','GHI')>0
-> add more conditions
suppose you want not Team = 'ABC' and Team = 'DEF' as Team only can hold one value
try use of match
where match(team,'ABC','DEF','GHI')>0
-> add more conditions
suppose you want not Team = 'ABC' and Team = 'DEF' as Team only can hold one value
Can you explain a little more what you mean by repeats 8 more times, but you are saying in the end of the script you have a where condition?
I think another approach could be use of 'Match' function -
Where Match(team, 'ABC','DEF', you can add more values)
Or you can create a variable with Set vTeamVar = your values and use this variable in match function -
Where Match(team, $(vTeamvar))
Thank you
Apologies the question wasn't posed better, but was able to receive help. Thank you for your help