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 am running a batch macro in my Alteryx workflow which gives 1 row as an output with different set of fields in each iteration. I need to append all these rows together by creating a new column, if required, after each iteration. Those rows which do not have values for the corresponding column should be replaced by 0.
Any idea how to do it?
After each iteration i need to append the output to a final output structure as below
thanks but my output is from a batch macro. at each iteration i get one output and the next iteration gives me a different set of columns. if i use transpose like how you did, then i need to dynamically change the key fields in transpose. is there a way to do that?