source="base_bds_adsl.csv" | table cd_enc
,N_BD, DDD,NUMERO_TERMINAL | eval FR=cd_enc
| eval str=substr(FR,2) |eval str1=substr(str,5)| eval str2=substr(str,1,len(str)-2)| eval str3=str2+str1
| table N_BD,str,str1,str2,str3,DDD,NUMERO_TERMINAL| rename str3 as "code"
| join code[search source="code_ENC_Modem_Translated.csv" Description!="DO" Description="$descr$"]
|table N_BD, code ,Description,DDD,NUMERO_TERMINAL | eval cid = DDD.NUMERO_TERMINAL |table cid,Description | rename cid as line_id
| join line_id [search source="Base_CPE_x_Customer_Number -Customer ID CNL+Terminal Number to Vendor Name mappings.csv"
| rex "((? .*))"] | table line_id,VendorID_FIELD4,Description | stats count(line_id) as "Number Of Faults" by VendorID_FIELD4
| rename VendorID_FIELD4 as "Vendor Name"
appears in red and in rex appears green color.
Getting Unbalanced Quotes error while saving view.
Kindly help me out soon. ..
Thanking
... View more