Remove rows with Strikethrough Data

Question

I have an Excel file with updated versions of the new records. I want to delete the records and have only the latest versions as shown below. Example screenshots are attached below. In this example, I would want to check if the "ID" column has strikethrough data and delete the record if it does, else keep it.
I am completely new to Alteryx and would be great if someone could help me with this. Please let me know if you need more information.

Raj · Answer

@SrikanthSampath

have you tried the macro attached
[Knowledge Sharing] Read Excel Data without Strike... - Alteryx Community
in this post

if yes what are the challenges.

SrikanthSampath · Answer

@terry10
Thank you for your response.
Currently, I am doing something like this. Creating a flag and filtering based on the flag in Excel. But it's a cumbersome process as I have close to 40-50 files that run the same process and I was looking to see if I can use Alteryx to read in the file, create the flag, and filter it without the extra step in excel.

terry10 · Answer

@SrikanthSampath

Does the strikeout apply to the whole row?  If so, it would be much easier to add a column in Excel to flag whether the row has strikethrough or not, then input into Alteryx and filter by this flag.

This is how you can do that.

Create user-defined function called "has_strikethrough".

To create this user-defined function in Excel:

1.  Press Alt-Fn-F11 to open VBA Editor

2.  From the Insert Menu, choose "Module"

3.  Paste this text into the editor window as shown in the screenshot below.

Function has_strikethrough(r As Range)
  has_strikethrough = r.Font.Strikethrough
End Function

4. Press Alt-Q to close VBS window and return to Excel

5. Save your file as .xslm (macro-enabled excel)

If my reply helped you, please mark it as accepted. Thank you!