Remove data from excel sheet contained in a data table

Help Studio
, ,
1

Hi, I have an automation that filters data for a Min Value.
After the filter I need to copy the data below the min value in a new excel sheet and that data needs to be removed from the Initial data.
How do I remove the data contained in “BelowMinDataTable” from “in_InitialTable”?

image
image1252×516 23.1 KB

2

say there are three columns in your tables “a”,“b”,“c”
left join “in_InitialTable" with "BelowMinDataTable” on all the columns(i.e. a,b,c)
now apply a filter datatable on the joined table to remove the rows in which
“a_1” is empty
Finally remove the “a_1”,“b_1”,“c_1” columns from the datatable

This will give you the rows from in_InitialTable which are not in BelowMinDataTable
Hope this helps :slight_smile:
Thank you,
Saurabh

3

@Allison_Cruz Can you please explain a bit more. Why you want to remove the data contained in BelowMinDataTable . From your screenshot I knew it has the filtered data

4

I want to remove it because the filtered data in BelowMinDataTable i scopied in another excel sheet, and in the initial data sheet that data needs to be excluded.

5

@Allison_Cruz You can try this

Once you have filtered data BelowMinDataTable and copied to another excel

  • Take another assign activity
in_InitialTable = same expression showed in the screenshot but use >= Operator

So that the in_InitialTable will have the values that was not present in BelowMinDataTable

1 Like