Managing Data Table columns

Help Activities
, , ,
1

Hello Forum, Today I come with a question that I feel I´ve had for a while, and I always like to ask them here no matter how simple there are.

For you to better understand my question I going to put it on a example…
Let´s say I have a Data Table called “dt_FullData” which contains 5 columns. Out of these 5 columns I want to add the data of two of them to a Queue in the orchestrator with a “Bulk Add Queue Items”. How can I configure the entry Data Table so the “Bulk Add Queue Items” only add the data from whichever column I want?
What are my options here?

2

Hey @Luis_Fernando ,

If you want to add only specified columns to Orchestrator then follow below steps

  1. Input datatable snapshot
    image

  2. Filtered Datatable snapshot (I removed AGE and SALARY columns)
    image

Below is the Output of Filter Datatable
image

After filtering you can add the filtered Datatable to "Bulk Add Queue Items "

Below is the Workflow Snapshot

image
image511×644 23.6 KB

Hope it helps You!

Happy Automation!

3 Likes
3

Hello @Vikas_M , thank you so much for your feedback!!
It´s really very exciting to see how different developers tackle development scenarios. Very useful.

4

Hey @Luis_Fernando ,You’re welcome! I’m glad to hear that you findmy post exciting and useful. As developers, we often encounter various scenarios, and it’s indeed fascinating to see the diverse approaches that can be taken to solve problems and create solutions. If you have any specific development scenarios or questions you’d like to discuss further, feel free to share, and I’ll be more than happy to assist you.
If not then please mark me as a solution and close this thread
Happy Automation :smile:

1 Like
5

Hi @Luis_Fernando

If you want to add column1 and column 3 then filter the datatable:
dt_FilteredData = dt_FullData.DefaultView.ToTable(False, “Column1”, “Column3”)
Then pass the datatable to your queue using bulk add queue items activity.

1 Like
6

Put this into the datatable property of Bulk Add Queue Items:

dt_FullData.DefaultView.ToTable(false,{“Column1”,“Column3”})

The array designates the columns you want.

1 Like
7

You don’t have to filter it into a separate datatable. You can just put the DefaultView expression directly into Bulk Add Queue Items, eliminating the need for creating extra variables.

1 Like
8

@Vikas_M You couldn´t have said it better!

9

@supriya117 @postwick This one I was seeking for!! Thank you both for providing so much clarity and great information. This one is definitely the lightest solution till now.

10

Hi, @Luis_Fernando you can mark the solved button if you have received the answer that you were looking for, from our community members. Thank you.

2 Likes
11

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