Filter redundant data and update excel sheet

Questions
1

I am building a workflow to remove redundant data from M365 Excel sheet and below are the steps:

  1. created an n8n form for data submission → data will be saved in M365 Excel sheet.
  2. Retrieving all the data from M365 Excel sheet → Get rows from sheet.
  3. IF node to filter the redundant data ( I AM STUCK HERE AND HAVE NO CLUE WHAT TO DO, How to filter redundant data is main issue for me. )
  4. Afterwards I want a node to update the excel sheet data by deleting the redundant data (is this possible in n8n or I am thinking in a wrong direction).

Please, help me in this scenario at your earliest. I am a beginner who is just playing around with n8n workflows.

3

Hey @Ibraheem_Mustafa , please clarify what you mean by ‘redundant data‘. Are these repeating rows, repeating values in a column, etc. ?

4

Redundant data means like repeated email address in the M365 Excel Sheet. For example, I am entering values in the form for the 1st time:
First Name: Tim
Last Name: bunker
Email Address: [email protected]

If I enter values in the form 2nd time:
First Name: John
Last Name: Doe
Email Address: [email protected]

Now, on same email address I am entering 2 values into the M365 Excel sheet rows, and I wan’t to use a node which would remove this redundant data and then I would like to send that to update the M365 Excel sheet.

I hope this clarifies @krisn0x .

5

Yes, thanks, but how should it decide which row to delete? Leave the first one?

6

on the basis of email address, redundant data must filter out and then updated into the M365 Excel sheet.

7

Can you check if this does what you need:

8

If I understand what you are looking to do - there is an update row mode in that node, where you can specify which column to look at for an existing value and which value to look for.

image
image758×1036 55.9 KB

9

Thank you @krisn0x It did removed all the duplicates, now I want to update the records of complete M365 Excel Sheet.
To Update: M365 Excel Sheet → Append or update sheet ( i tried it but it is not updating IDK Why)

10

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