Transform of Balance Sheet data

[hiteshnpwc]

Hello Everyone,

I am looking to build a workflow that has 2 inputs (Balance sheets)  and looking for an Output. I have attached the screenshot of 2 input data file and expected output

[caltang]

It's great that you provided images, but it will be more helpful to provide some sample data + an excel file of your expected output for the community to better guide you.

But just from the image, I'm going to say that the design you're aiming for may not match 100% to your needs. You'll need to employ some flexibility because the Alteryx output is standard with its data framing via Outputs even with a template.

-Cal

[hiteshnpwc]

@caltang  Thank you for your reply. Attached the data file. 

[caltang]

Hi @hiteshnpwc

I did not go all the way because I am not sure how you classify what is Asset and Liability. Based on my workflow, that should give you some ideas as to how you can achieve your output of choice.

I hope this gives you some ideas - please try to build on this.

-Cal

[hiteshnpwc]

@caltang Thank you for your input. I will review and make the changes.