Extract specific columns and values

Help Activities
, , ,
1

Dear Master,
Please help me on below scenerio.
I have “Raw” report and A excel template(“SpecificColumn”) which will contain only column name.
i need to extract the information of those columns only which is mentioned in the excel “SpecificColumn” sheet from Raw report.

i have attached the excel file with sample output
please help. Input&Output.xlsx (16.1 KB)

2

:thinking:

1 Like
3

Hello @Sonia_012 ,

you can write LINE Query for that

outDt.AsEnumerable().Select (function(row) row(“yourColumnName”)).ToList()

Cheers

4

m not sure if i understand correctly… do i need to take my column names into one variable ?
and do i need to do this inside for each row ?

1 Like
5
  • Read excel - Specific Column as sheet
  • for each row
  • use this within the loop rawDataTable.AsEnumerable().Select (function(row) row(“yourColumnName”)).ToList()
1 Like
6

hi
m Sorry m new to this, m not able to get the proper output with this method…
possible for you to share sample xaml file ?? i have attached excel for reference…

7

can anyone please help me on this…

8

i have used counter for specific column sheet… and in assign i have passed awDataTable.AsEnumerable().Select (function(row) row(“yourColumnName”)).ToList()…

as i am getting counter i am getting the values columnwise one by one…
how do i pass on to datatable?
also there is no header how do i add header

please help

1 Like
9

Hi

Sorry for the delay, Can you explain me your requirement?

10

Check this below workflow, @Sonia_012
Uipath_GetSepcificColumns.xaml (6.4 KB)
Hope this may help you :slight_smile:

1 Like
11

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