I am looking to add a blank row if the field Account contains "Total" for better formatting.
Hi @afontaine
I did some trick to get there.
- Add a RecordID
- Change it to Double Type
- Add a filter to select records where Account contains "Total"
- Add .5 to RecordID
- Use DataCleansing with all options checked to remove everything from these fields
- Union this to the original Dataset
- Sort by RecordID
- Deselect Record ID.
I simulated an example. WF appended.
Cheers,
I was able to get the dummy row to display full height by using a formula tool to add a non-breaking space(ALT-0160) to the Account field. I originally tried with a regular space, but excel hid the row anyway.
Note I had to remove your macro for the workflow, because I don't have it.
Dan
@Thableaus
This solution works great. Thanks so much. One thing is that when I output it to excel or pdf it is hiding those blank rows anyway to fix this?
