This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I was happy to see that the ability to remove null columns in the Data Cleansing tool! But I also wanted to be able to remove columns that were filled with a constant (e.g., all 'N/A', all with the same load date, or all 0's).
So, I drilled down to the sub-macro called removeNullColumns and changed the condition from CountNonNull to CountDistinct and subsequently filtered out where CountDistinct_Value <=1.
@David-Carnes I also hacked the Publish to Tableau tool to get around network policy of updating passwords. But instead of requiring AD credentials, I setup authentication via personal access token (PAT) on Tableau site, which won't change.
@patrick_digan Thank you for sharing these excellent hacks! Data type in the formula tool, default to custom filter, and sample 1 record - yep, these hacks cut out the first clicks I repeatedly use on these tools! Well done. I have marked your response as a solution. 🙂