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.
How to remove subtotals and blank lines from my data?
Can you please provide sample input data and expected output.
I have a file that have blank rows and subtotals. I would like to remove them. I tried using data cleansing but it does not seem to be working.
Please see screen shot below.
Should I use the data cleansing tool first to remove blank rows and subtotals?
You can use Filter tool BU is not null.
Can you provide sample data file.
Hi @dvernon ,
Similar to what @atcodedog05 mentioned in his reply, please find attached a sample workflow to do this.
Note:- The workflow uses sample data.
Hope this helps.
My apologies, please see attachment.
Thanks for the sample data.
Please find attached a sample workflow.
You can use filter like below. To remove sub total rows.
Hope this helps : )