This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to solve an issue - I'm building a workflow that generates 12k individual sheets with information about airfields - my workflow works great with the majority of the inputs, but in cases where there is no data reaching a crosstab / transpose, all future calculations error out, and I can't union the data together. Ideally, the end of the crosstab I'd like to just have an output with a single column name and no data, so I can just union it together. But it seems that each time I make a fix for cases where there's no incoming data, it messes up the rest.
I tried the 'ensure data' with CREW macros, but unless I'm missing something, it won't keep a column when there's no data.