Data table select multiple columns, no filter condition

[DEATHFISH]

I am using the 2017 version of UiPath so there is no Filter Data Table activity.

How do I select entire columns from a data table as a separate data table? Without looping or filter conditions as mentioned in other answers. Couldn’t find any definitive answer for this

Thanks

[Karthick_Settu]

Check this posts.

Activities - Filter Table

DataTable.select() versus FilterDataTable activity

Hello, 1)Can you please explain the difference between DataTable.select() and filter Data table activity ? When to prefer each and what is more efficient?, as of now I know one difference i found is return type.It would be great if you attach workflows for corresponding 2)And also how to use Datatable.select type for string type of columns in data table I have given like this [image] getting issue [image] Thanks in advance.

How to custom sort a datatable

Where do you get an error? I personally didn’t try a complete workflow with data from Excel, just the datatable manipulations, and I don’t have it installed on this PC. My hunch is that the column names are not A, B, C and so forth, and this will raise an exception where you assign to myView.Sort. You can verify this with the Output data table activity, which will give you a String representation of the table that you can write to output.

Using DataView.ToTable Method as input to a Write Range

Hi there, I’m trying to extract a single column from a DataTable variable and to use this column as an input to a Write Range Activity. The following method should return a DataTable which could be used as an input, but I haven’t figured it out yet. The VB Expression for the Data Table input that would return a datatable made from the column 0 of a given dt DataTable variable would be something like dt.DefaultView.ToTable(false, dt.Columns(0).ColumnName) but it awaits an identifier ? I’ll k…

[DEATHFISH]

Thanks I understand that there are other posts regarding this but these do not fulfil the use I want to achieve that’s why I am asking here. I just want to select entire columns and present it as another data table, without any filtering or sorting or looping as mentioned in these answers

Or, how do I modify the DataTable.Select method to not have any filtering criteria?

[indra]

@DEATHFISH Download this zip file for your reference

[Vijay_Tulsalkar (Vijay Kumar C Tulsalkar)]

You Can try this
Datatable.defaultview.totable(false, “columnnameA”,“columnnameB”).Copytodatatable

this will give you the column required without filtering

[nidheessingh]

@Vijay_Tulsalkar

Copytodatatable

Hello @Vijay_Tulsalkar,

How can i pass WHERE condition in dtExcel.defaultview.totable(false, “TransactionNumber”,“Status”).Select.CopyToDataTable ?

Regards,
Nidhees

[Vijay_Tulsalkar (Vijay Kumar C Tulsalkar)]

Hi @nidheessingh

there are many ways to do it one approach would be the following…

(From x In (dt.defaultview.totable(False, “columnnameA”,“columnnameB”)).asenumerable()
Where YourCondition
Select x).copytodatatable

2. Approach

dt.defaultview.totable(False, “columnnameA”,“columnnameB”).Select().Where(Function(x) YourCondition).CopyToDataTable

Example:

dt.defaultview.totable(False, “columnnameA”,“columnnameB”).Select().Where(Function(x) Convert.ToString(x(“columnnameA”)).Equals(“xyz123”)).CopyToDataTable

[nidheessingh]

@nidheessingh

lect.CopyToDataTable ?

Hello @Vijay_Tulsalkar,

Thanks for your reply…

I am not aware of LINQ and therefore, it is very confusing for me.
I am sharing an excel sheet in which, there is a column “ProviderTransactionNumber” that have duplicate transaction numbers which denote a single transaction of a customer.

Another column is “Status” which denote 2 types of Status “REVERSED” and “REVERSAL SUCCESS”.

Status “REVERSED” means reversal process initiated from the bank for a transaction number. When the amount is credited to Customer A/c successfully then, there is another status is triggered by the bank which is called “REVERSAL SUCCESS” for the same transaction number and therefore, “ProviderTransactionNumber” column has the duplicate transaction number.

Now, my requirement is to fetch a transaction number that has both Statuses - “REVERSED” and “REVERSAL SUCCESS” and generate a single row of transaction. Likewise, all duplicate transaction numbers, I have to generate unique records in the following format (for e.g.)

DT_Out_Result_11 - Copy.xlsx (227.9 KB)

Regards,
Nidhees

[Vijay_Tulsalkar (Vijay Kumar C Tulsalkar)]

Hi @nidheessingh

Check if this met your requirement . Pass the required Excel file Path …

Final.xaml (4.7 KB)

[nidheessingh]

Hello @Vijay_Tulsalkar,

Thank you so much.
Your given solution worked as per requirement.

My last query regarding same excel data…

There are some more transaction numbers under “ProviderTransactionNumber” column which are not duplicate and its Status can be either “REVERSED” or “REVERSAL SUCCESS” only.

Status - “REVERSED” denotes about those transactions whose reversal process has been initiated but the amount has not been credited into Customer A/c and therefore, such transactions have no duplicate transaction numbers under “ProviderTransactionNumber” column and accordingly its “REVERSAL SUCCESS” status entry not available in excel sheet.

Status - “REVERSAL SUCCESS” denotes about those transactions whose reversal process has been completed and the amount has also been credited into Customer A/c and therefore, such transactions have no duplicate transaction numbers under “ProviderTransactionNumber” column because it is a possibility that there may be no “REVERSED” status entry available in the excel sheet.

So, for this type of unique transactions whose status is either REVERSED or “REVERSAL SUCCESS” only and has no duplicate transaction number, I also have to capture these using the previous query as you mentioned in “Final.xaml” workflow.

For your understanding, I am sharing my updated Input data format and accordingly expected output plus updated excel sheet as an attachment.

DT_Out_Result_11 - Copy.xlsx (220.0 KB)