Forum Discussion
Solved
SINGLE COLUMN WITH HIERARCHICAL DATA
I'm working on a project where I need to aggregate data from a flat file that contains region codes (starting with "R") and chapter codes (starting with non-"R" letters). The data needs to be aggrega...
Thank you !! I was able to resolve it myself
Hi Tan_g,
I hope you're doing well! I just wanted to follow up on the query you posted regarding the sample data. Have you had a chance to review the details we requested, including a few rows from your flat file (Region/Chapter codes, PSC code, NAC code, and values to be aggregated), the region mapping table, and an example of the expected output after aggregation?
If you're still facing any difficulties or need further assistance, please don't hesitate to let us know we're happy to help!
Best regards,
Prasanna Kumar
Thank you !! I was able to resolve it myself