removing empty rows in a more efficient way

[AbdulBasit]

Hi there i was wondering if there is a more efficient way of removing empty data than this.

[atcodedog05 · Accepted solution]

Hi @AbdulBasit 

Here is a modification which will improve the performance of @PhilipMannering workflow

Since if one column has null row it should be removed. So if one ID is there in Null() group it should be removed.

Basically transpose might create duplicates of IDs like below.

Which when it goes to Join it might create multi join results to data explosion.

So what i did is i have added a unique tool which will take single ID only once in the Null group to join and reduce data explosion. Since you said 50 columns you could use all the help you can get😀

Hope this helps 🙂

[estherb47]

Hi again @AbdulBasit 

The solutions provided by @DavidP  and @PhilipMannering will both work for as many columns as your data have, and would definitely be more efficient from an ease of use.

If you're looking for speed, in general the Data Cleanse tool can be slower than the transpose / filter method. 

Cheers!

Esther