Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Workflow

dvernon
5 - Atom

How to remove subtotals and blank lines from my data?  

7 REPLIES 7
atcodedog05
20 - Arcturus

Hi @dvernon 

 

Can you please provide sample input data and expected output.

dvernon
5 - Atom

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.

dvernon_0-1627583273411.png

 

dvernon_1-1627583309052.png

Should I use the data cleansing tool first to remove blank rows and subtotals?

 

 

atcodedog05
20 - Arcturus

Hi @dvernon 

 

You can use Filter tool BU is not null.

 

Can you provide sample data file.

JagdeeshN
11 - Bolide

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
5 - Atom

My apologies, please see attachment.

JagdeeshN
11 - Bolide

Hi @dvernon ,

 

Thanks for the sample data.

 

Please find attached a sample workflow.

 

Best,

Jagdeesh

atcodedog05
20 - Arcturus

Hi @dvernon 

 

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

atcodedog05_0-1627584354844.png

 

Hope this helps : )

 

Labels