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.
Is this possible? I can join the input tables using the union tool, I have transposed using EE ID and Cost Centre as key fields and then cross tabbed again with EE ID and Cost Centre as key fields. This giving me the desired number of rows.Fields EE ID and Cost centre are populated. Struggling to figure out how to manipulate the remaining fields for desired output. any help would be great.
I was exploring this earlier - my issue is that EE ID 9 from the 3rd table does not join the output as it is unique. Would also need the period columns populated if null. I was trying to use a multirow formula but it seems a little tedious!
I created a workflow using Join Multiple, added a Formula tool to fill NULL values for EE ID and Cost Centre and a Summarize tool to identify the periods, added the using Append Fields then. Does this solve your problem?