Trying to select only two columns from datatable without any condition but the above query taking all the columns from the datatable kindly help in linq query

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

Hi @Aravinthan

Use it based on se lect query

Thanks
Ashwin.S

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”)

1 Like

All the columns it picking bro

@Aravinthan Can you share the screen shot or attach the workflow

working bro thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.