I have csv data Want to update value in Name column from Id column

[Garyy (M)]

Please check the screenshot
Check Id value and put in Name column
Ex.
ID(123)=Name(Jeff)
ID(444)=Name(John)

[rlgandu (Rajyalakshmi Gandu)]

@Garyy

Fill column based on ID and Name

Hi @Zac_Soh, I’ll suggest to follow the steps below, Take For Each Row activity (to iterate on the Datatable), then take If activity with condition —> row(“Name”).ToString=“” Take Assign in Then section of If activity to store that ID whose name is empty. ID = row(“ID”).ToString Now take one more For Each Row on DT, after that assign in same then section. take If activity inside that for each row with condition —> row(“ID”).ToString=ID And row(“Name”).ToString<>“” —> to serach that ID with…

[Anil_G (Anil Gorthi)]

@Garyy

Try this in invoke method…send dt as in/out argument and dt1 as in argument and both needs to be assigned with same datatable variable in arguments

Dt.AsEnumerable.ToList.ForEach(sub(r) r("Name") = dt1.AsEnumerable.Where(function(x) r("ID").ToString.Equals(x("ID").ToString) and Not String.IsNullOrEmpty(x("Name").ToString)(0)("Name"))

Cheers

[Garyy (M)]

Hi @rlgandu Solution is right but if ID row is blank then other column get above row value, i want only value which has ID

[Garyy (M)]

Thanks @Anil_G but i don’t want to use invoke method activity, you have any other solution

[rlgandu (Rajyalakshmi Gandu)]

@Garyy

in for each loop take if conditin
Not String.isNullOrEmpty(CurrentRow(“ID”).ToString)
Perfrom the actions in true block
in else
Use break

[Anil_G (Anil Gorthi)]

@Garyy

Try the steps

1. For each row in datatable dt
2. Inside loop use if condition with String.IsNullOrEmpty(currentRow("Name").ToString)
3. on then side use currentRow("Name") = dt.AsEnumerable.Where(function(x) currentRow("ID").ToString.Equals(x("ID").ToString) and Not String.IsNullOrEmpty(x("Name").ToString)(0)("Name")

cheers

[shravan.prajapati]

Try this below code . Hope it will be helpful.

Main.xaml (18.3 KB)

[Garyy (M)]

Can you help me with that error

[Anil_G (Anil Gorthi)]

@Garyy

Looks like I missed a bracket please check this

dt.AsEnumerable.Where(function(x) currentRow("ID").ToString.Equals(x("ID").ToString) and Not String.IsNullOrEmpty(x("Name").ToString))(0)("Name")

cheers

[Garyy (M)]

Getting this error

[Anil_G (Anil Gorthi)]

@Garyy

is DT having data ?

cheers

[Garyy (M)]

yes it has data
I shared the screenshot above

[Anil_G (Anil Gorthi)]

@Garyy

As per error looks like dt is null or empty

Cheers

[Garyy (M)]

[Anil_G (Anil Gorthi)]

@Garyy

Looks like there are few empty rows…before running this can you filter on the empty rows please

cheers