To assign selective column /

[Happydayyy (22035153d)]

May I ask what went wrong to this activity

I refer to this video for assigning the new datatable for selected column.

Selective Columns Write Columns into new Excel sheet #UiPath #RPA

My problem assign to value is:
dtinput.DefaultView.ToTable(False,dtinput.Columns(“Date Start”).ColumnName,dtinput.Columns(“Date End”).ColumnName,dtinput.Columns(“grouped sample ID”).ColumnName,dtinput.Columns(“T1a”).ColumnName,dtinput.Columns(“T2a”).ColumnName,dtinput.Columns(“average fineness”).ColumnName,dtinput.Columns(“repeatability”).ColumnName,dtinput.Columns(“FA Number”).ColumnName,dtinput.Columns(“Type”).ColumnName)

I need to select part of data from 2.1 Summary to the template sheet (MU-Rep (output))
in which my target output selected column is:

Thank for helping me cope with this problem.

Workflow:

[ppr (Peter Preuss)]

@Happydayyy
please do not miss to check out also your other Topics, when answers there are in relation with this Topic

@Happydayyy

what went wron

checkout that the right variable was used and the DataTable is set and not null

Debugging and Debugging panels will help

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

@Happydayyy

My problem assign to value is:
dtinput.DefaultView.ToTable(False,dtinput.Columns(“Date Start”).ColumnName,dtinput.Columns(“Date End”).ColumnName,dtinput.Columns(“grouped sample ID”).ColumnName,dtinput.Columns(“T1a”).ColumnName,dtinput.Columns(“T2a”).ColumnName,dtinput.Columns(“average fineness”).ColumnName,dtinput.Columns(“repeatability”).ColumnName,dtinput.Columns(“FA Number”).ColumnName,dtinput.Columns(“Type”).ColumnName)

we can do it with a much shorter syntax

dtinput.DefaultView.ToTable(False, new String(){"Date  Start","Date End","grouped sample ID","T1a","T2a","average fineness","repeatability","FA Number","Type")

Just pass a String Array with the needed Column Names

[vrdabberu (Varunraj Dabberu)]

Hi @Happydayyy

Try the below syntax:

dt_Target = dt_Input.DefaultView.ToTable(False, New String(){"Date Start", "Date End", "grouped sample ID ", " T1a", "T2a", "average 
fineness ", "repeatability", "FA Number", "Type"})

Attached the excel file too. Check Sheet1 is the expected output from your given excel file.
template looking up (2).xlsx (73.5 KB)

Regards

[Happydayyy (22035153d)]

I still get a mistake here after using the shorten one

[Happydayyy (22035153d)]

Can anyone help me to solve it issue. Many thanks

[vrdabberu (Varunraj Dabberu)]

Hi @Happydayyy

Please use the below query:

targetdt = dtinput.DefaultView.ToTable(False, New String(){"Date Start", "Date End", "grouped sample ID ", " T1a", "T2a", "average fineness ", "repeatability", "FA Number", "Type"})

Regards

[Happydayyy (22035153d)]

still hv error…

[vrdabberu (Varunraj Dabberu)]

Hi bro remove that targetdt = from that query @Happydayyy

dtinput.DefaultView.ToTable(False, New String(){"Date Start", "Date End", "grouped sample ID ", " T1a", "T2a", "average fineness ", "repeatability", "FA Number", "Type"})

Regards

[Happydayyy (22035153d)]

but in the ‘’ sheet, the average
fineness is exist.

[vrdabberu (Varunraj Dabberu)]

HI @Happydayyy

try now

dtinput.DefaultView.ToTable(False, New String(){"Date Start", "Date End", "grouped sample ID ", " T1a", "T2a", "average 
fineness ", "repeatability", "FA Number", "Type"})

Regards

[Happydayyy (22035153d)]

Thank you very much for this query.
However i faced another issue for this robot

May I ask how i can solve it?

[vrdabberu (Varunraj Dabberu)]

HI @Happydayyy

You are using the excel application scope right. So, you can directly use the write range (excel activity).

Use the below activity instead of write range workbook.

Don’t forgt to mark the add headers in properties panel as true.

Regards

[Happydayyy (22035153d)]

UiPath - split excel data into multiple sheets based on the column values dynamically

Actually I am following her video in spilting data to multiple sheet based on “Type”. It’s ok to spilt out multiple sheet?
For example, one sheet is for ‘Type (4N)’ and paste all column data for 4N;one sheet is for ‘Type (3N)’ and paste all column data for 3N

[Happydayyy (22035153d)]

This robot i combined these two video for reference. now the datatable part is solved but i still coping with the spilting excel sheet part.

[vrdabberu (Varunraj Dabberu)]

Hi @Happydayyy

Yes you can split the sheets as per your requirement.

Have your above query resolved?

Regards

[Happydayyy (22035153d)]

It’s only can output sheet 1 without spilting data based on …

How can I set something to spilt multiple sheet (i…) based on “Type” ?

[ppr (Peter Preuss)]

@Happydayyy
we support you on your several topics, but also encounter, that these topics are not straightforward handled in flow

• topic creation - use case description
• clearing of requirements, if needed
• solving
• topic closing

We also prefer to scope 1 topic = 1 case. This strict pattern helps other reasearchers faster to find solutions for similiar cases

initial this topic was about: shortening a data table on a subset of columns

with:

@Happydayyy

How can I set something to spilt multiple sheet (ie 4N, 3N, ky…) based on “Type” ?

a new case is inserted in this topic, where we prefer to open a separate topic for this and not mismatching it with the origin topic

Thanks for your support

Solution approach preview for:

@Happydayyy

spilt multiple sheet (ie 4N, 3N, ky…) based on “Type” ?

• grouping the data and splitting the groups into different data tables
  [HowTo] Overview on different options for grouping data and processing the groups

[Happydayyy (22035153d)]

Okay refer to About spliting the excel sheet based on different types of data
This post now. Thanks all so much