I have a file that I am running with HFM and a Longview addin and then utilizing a workflow to pushout 8 CSV files. The 8 tabs are dynamically reading off of the two HFM refreshes. The 8 tabs have formulas down to row 10k but only populate to say 5k etc. My workflow is pushing out the CSV files and is showing that there is data in all of the cells that are after in this example 5k. Is there a way to prevent this? When I am trying to import this into Longview, it is reading those rows and rejecting the loads.
Nope not oversimplifying at all! I tried to do that but it seems like it still does not work. I used the "is not null" but it didn't appear to help? I was wondering if there was a way to use the Select Command or perhaps the input command?
[Zimmer Biomet - The Power of Us]
Samantha Woodling Senior Tax Analyst 574-373-2788574-373-2788> Direct email@example.com