Hi all,
Below I have attached a workflow which has a input dataset and that needs to be transformed into the Given Desired Output Format.
Note: The Headers are in Row 1. Also I need to Capture all the columns dynamically till the keyword "END" is detected in the First Row. hence we need to capture details till F45. Also if the first Row is Null() Then that entire column needs to be discarded. "F2, F48, F49" needs to be discarded.
The output shall have 3 columns - Entity Name, Account Name and Values. Row 1 contains the entity name, Column 1 has the Account Names and look into the desired output file for the corresponding values. I need to populate the values for each All the entities tied to all the accounts.
