Made it work! Next Challenge 3 Log_Sources
|inputlookup cs_ad.csv
|eval missmatch=if(identity_ad=identity_sep," ","x")
|eval ad_has_value=if(identity_ad!="*","x"," ")
|eval sep_has_value=if(identity_sep!="*","x"," ")
| fillnull value=" " identity_ad, identity_sep
| eval result2=case(identity_ad==identity_sep, identity_ad,
identity_ad!=" " AND identity_sep!=" ", identity_ad+" / "+identity_sep,
identity_ad!=" ", identity_ad,
identity_sep!=" ", identity_sep,
1=1, "ERROR")
|table identity_ad identity_sep result2 ad_has_value sep_has_value missmatch
... View more