Remove duplicate columns

[yzanferr]

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

[kelsey_kincaid]

Hi @yzanferr ,

Would something like the attached work for you? 

Input: 

Flow:

Output:

[yzanferr]

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.

[kelsey_kincaid · Accepted solution]

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

[yzanferr]

@kelsey_kincaid it worked for some data, but I think that is some Null written as a string. Is it possible to convert nulls automatic for numbers?