User I Need A linq Query in uipath from an excel sheet to another excel workbook

Help Activities
, ,
1

I Need A linq Query in UiPath from an excel sheet to another excel workbook , iam giving the query below to append the datas and share a screenshot of Workbook file in which the given first 3 columns Dt_Pending.DefaultView.ToTable(False,“Customer Number”,“Material”,“Pend.Qty.”)

image
image1920×1080 224 KB

these was the excel sheet i want to appent on the datas on given columns

2

Hi @Melbin_Antu1

Try this query once:

Assign activity:
Dt_Appended = (From row In Dt_Pending.AsEnumerable()
               Select Dt_Pending.Clone().LoadDataRow({row("Customer Number"), row("Material"), row("Pend.Qty.")}, False)
              ).CopyToDataTable()

Hope it helps!!

3

Hi @Melbin_Antu1

  1. Read Range - souceDataTable

LINQ query to select specific columns

resultDataTable = sourceDataTable.DefaultView.ToTable(False, “Customer Number”, “Material”, “Pend.Qty.”)

Hope this helps

4

Thanks Its Working solved the issues