Hi team, I have below excel data - [image] I have 2 values - “currency” and “account” First I have to check if [first 2 characters of " currency" ] is present in Remit_ID rows.If it has a unique row match , it should return the corresponding “Supplier_ID” for that Remit_ID. If its present in mu…

have a check at: [grafik] (From d In dtData.AsEnumerable Let sc = strCUR.Trim.Substring(0,2).toUpper Let sa = strACC.Trim.Substring(strACC.Trim.Length - 4).toUpper Let rm = d("Remit_ID").toString.Trim.toUpper Where rm.StartsWith(sc) Or rm.EndsWith(sa) Let cm2 = Convert.ToInt32(rm.StartsWith(sc)).…

Find match for rows in excel

Help Studio

Gokul001 (Gokul Balaji) September 5, 2022, 11:26am 4

Hi @gokul1904

Have a look on the XAML file

ExcelProcessing.xaml (10.6 KB)

Regards
Gokul

1 Like

Index and length must refer to a location within the string. Parameter name: length in Assign

Topic		Replies	Views
Excel help please - filter and fetch values Studio studio , question , activities_panel	7	966	September 5, 2022
Filter excel data based on a matching rule - if col1 value(account) is same and col2(amount) is matching as debit & credit, need to exract the rows Help excel , activities , studio	1	1472	June 6, 2019
Update data table row if a match Help	5	2752	April 1, 2020
Get Value of Second Column each row Help	1	1844	April 8, 2019
Compare the value is there or not in excel and get the corresponding column value Studio studio , question , activities_panel	5	980	February 12, 2022

Most Active Users - Yesterday
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil
More details...

Find match for rows in excel

Related Topics