I need to
a. Remove the row gap between two tables in a template
b. Output result without distrurbing the existing template into a new excel
P.s. To remove the gap i used the formula tool through !IsNULL ([Date]) but was unable to preserve the existing template of imported sheet.
Hi! Just wanted to clarify--are you looking to do this in Designer or Designer Cloud?
designer
@vishalnegi I've moved your post into the Designer discussion forums so that you can get the help you need! I would also recommend looking at this blog to see how you can use the blob tool to preserve formatting in Excel files: https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/...