If no match found in a lookup can we add a key word as "Match" not found

[MANISHA_V_ARORA (Miss Arora)]

Update column values of datatable based on the lookup result from another excel sheet

[columndata] For a column, we can have combination of different values as in here, it can be BLV, ABC,XYZ etc. We need to lookup into another excel file what ABC mean for example, get that result and paste here in c_prop_cd wherever we find ABC in this column in one go… How this can be done considering we have huge amount of data…

In continuation to above post for below code:

dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“c_prop_cd”)= If(dt2.AsEnumerable().Where(Function(r) r(“c_prop_cd”).ToString.Equals(row(“c_prop_cd”).ToString)).Count<>0, dt2.AsEnumerable().Where(Function(r) r(“c_prop_cd”).ToString.Equals(row(“c_prop_cd”).ToString))(0)(“c_prop_desc”).ToString,row(“c_prop_cd”).ToString))

If no match found in a lookup how do we add a key word as “Location Unknown”

@NIVED_NAMBIAR @Divyanshu_Divyanshu @prasath17

[NIVED_NAMBIAR (NIVED N)]

Hi @MANISHA_V_ARORA

Check this code

dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“c_prop_cd”)= If(dt2.AsEnumerable().Where(Function(r) r(“c_prop_cd”).ToString.Equals(row(“c_prop_cd”).ToString)).Count<>0, dt2.AsEnumerable().Where(Function(r) r(“c_prop_cd”).ToString.Equals(row(“c_prop_cd”).ToString))(0)(“c_prop_desc”).ToString,“Location Unknown”))