How to match data between 3 columns

[Filipe_Silva]

Hi guys,

Hope anyone can help me.

So I have, an excel with 3 columns, let´s say GroupDocs, Docs, Validation.
What I want to do is, for each row in GroupDocs and Docs, check if row in Validation is true or false.

My objetive is that whenever in my GroupDocs I find a document, check is this is true or not.

Please say if further context is needed.
Thank you

[Gokul001 (Gokul Balaji)]

Hi @Filipe_Silva

Refer this thread

Compare multiple columns in excel

@nabeelu About the Scenario and Approach: Sheet 1 = D1 Sheet 2 = D2 Definition of a Group: D1.ID Definition of a Match: In a Group D1.Value = D2.Value Group D1 Data Process every Group one by one - D1Stack Retrieve from D2 all items having the same Group Key - D2 Stack Find the matches between D1Stack And D2 Stack - Matches Remove Matches D1Matches from D1Stack, Similar doing it with D2 take from D2Stack items of the count of remaining elements in D1Stack or less if D2Stack.Count < D1Stac…

Datatable comparison using multiple columns

Hi @John_Dara Following the attached workflow created using the Linq queries with minimal activities. Used the received and sent excel attached by you in your question Used Join datatable with full outer join to join receive and sent files Used the following linq query to update the both amount_remarks and name_remarks at a shot (From d In dtNewBuild.AsEnumerable Let amount_remarks = If( CDbl(d(“Amount_Sent”))=0, “Amount not sent”, If(CDbl(d(“Amount_Credited”))=0, “Amount not credited”, If…

If possible can you share the Sample input excel file and output

Regards
Gokul

[Filipe_Silva]

Thank you for the response @Gokul001

Here is the Sample Excel file

[Gokul001 (Gokul Balaji)]

Can you elaborate the query @Filipe_Silva

[Filipe_Silva]

I want to check the value in my column Validation

For this, I need to go row by row, let’s say:

for my Group1 and 1(Doc), check the value in Validation Column
for my Group1 and 2(Doc), check the value in Validation Column

and so on

It this good for you?
Thanks

[Gokul001 (Gokul Balaji)]

Hi @Filipe_Silva

@Filipe_Silva

for my Group1 and 1(Doc), check the value in Validation Column

You need to check the Validation column Contains True

Right?

[Filipe_Silva]

Yes that is what I need

[Gokul001 (Gokul Balaji)]

HI @Filipe_Silva

You can try to give condition like

Excel application scope → Give excel path

Read range Activity → Enter the sheet name

Create an out datatable in the properties panel (DTOutput)

Use For each row in DataTable

IF Condition
Row(“Validation”).Tostring.contains(“True”)

If Then
You can process the flow

Hope it will help you

Regards
Gokul

[ppr (Peter Preuss)]

when readin int the excel into a datatable (read range) we would expect following result

Group1|1|true
|2|True
…

so we would

• filling up the missing GroupX column values
• grouping the data on GroupDocs
• processing / evaluating the groups

For filling up, have a starter help here:
FillUp_BlockBlanks.xaml (9.3 KB)

Grouping data have alook here:

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

[Filipe_Silva]

Giving further context,

I need to extract documents from a website, but I need to extract them depending on the parameter (Emp or Part).
Lets say my parameter is Emp, I do a search on the website for this parameter and it returns the documents refering to Emp, then I need to to check in my excel which of the documents I need to extract, by checking the value in column Emp.

If true, I extract
If false, I do not extract.

Hope it’s more accurate now
thank you

[Filipe_Silva]

@Gokul001 , please consider the context I added please
Thank you