Name AND School AND City AND Country
Name AND School AND Country
data
Last
data
Find
Replace
FindAny
Replace
|
4 = if IsEmpty([4]) then [3] else [4] endif
3 = if [3]=[4] then null() else [3] ...
1.Name contains('Tom') AND School contains ('ABC High School') AND City Contains('Vancouver','Toronto') AND Country Contains ('Canada')
2.Name contains('Adam') AND School contains ('ABC High School') AND Country Contains ('Canada')
Data
Find
Replace
FindAny
Replace
Data
Last
4 = if IsEmpty([4]) && contains([3],"Country") then [3] else [4] endif
3 = if [3...
Horizontal
Parse AND