Remove duplicate columns

Hello, I'm a new user to Alteryx. I was wondering if anyone could help me.

I do have a massive excel with several columns (1632 to be precise). It probably has a lot duplicated columns, not only headers, but hole data.

I need to do 2 tasks:

1- Verify if there are identical columns(not only headers, they must be 100% identical) and delete them;

2- Verify is a column only present nulls or zero and delete the column. The Nulls are saved as strings.

The excel is to big to do it manually.

Thanks,

Yuri

Preparation

Accepted answers

@yzanferr Sorry about that! Try the attached and it should accomplish both goals.

Would something like the attached work for you?

Input:

Flow:

Output:

Hello @kelsey_kincaid Thanks!!!

It solved part 1 of my quest! I still need to remove the columns that contain only null(as a string or not) and zeros.