Workflow

[dvernon]

How to remove subtotals and blank lines from my data?  

[atcodedog05]

Hi @dvernon 

Can you please provide sample input data and expected output.

[dvernon]

Frist Step

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?

[atcodedog05]

Hi @dvernon 

You can use Filter tool BU is not null.

Can you provide sample data file.

[JagdeeshN]

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.

Best,

Jagdeesh

[dvernon]

My apologies, please see attachment.

[JagdeeshN]

Hi @dvernon ,

Thanks for the sample data.

Please find attached a sample workflow.

Best,

Jagdeesh

[atcodedog05]

Hi @dvernon 

You can use filter like below. To remove sub total rows.

Hope this helps : )