Iam havind 10 columns but iam trying to select 2 columns alone but it taking all the columns kindly help
(From x In EmpDT.AsEnumerable()
Select EmpDT.Clone.Rows.Add ({x.Item(1),x.Item(4)})).ToList
Iam havind 10 columns but iam trying to select 2 columns alone but it taking all the columns kindly help
(From x In EmpDT.AsEnumerable()
Select EmpDT.Clone.Rows.Add ({x.Item(1),x.Item(4)})).ToList
Pls give exact syntax it would b helpful bcz all columns coming for me for the above query
Hi @Aravinthan
Take this
Dtoutput.select(“[column name]=‘value’ or [column name]=‘value’”). copy todatatable()
Print the output in output datatable activity
Thanks
Ashwin.S
If there 5 columns in datable using select linq iam trying to select only 2columns not where condition for eg if we have colA,colB ,colC and ColD we need to select only cola and colb values alone
Set condition for
For 4 columns in linq
Then statement use assign activity for the above query
Thanks
Ashwin.S
@Aravinthan If you want choose particular columns than use below query
Dt = Dt.DefaultView.ToTable(False,”Column1”,”Column2”)
Thanks bro is working how to pass collumn as ItemNumber without columnname in this query
@Aravinthan After read range In assign activity(dt) use these query
Dt = Dt.DefaultView.ToTable(False,”Column1”,”Column2”)
All the columns it picking bro
working bro thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.