Hi,
For a project where I need to wrangle data using SQL, I will need to rearrange some 75,000 files which have more or less a format like the attached files.
They contain two way data tables which I need to convert to one way data tables. Ideally, the final table will look like this :
Reliance Cash Flow 2018-03 gross revenue 2878908800
Reliance Cash Flow 2018-03 tax refunds 8870800
Reliance Cash Flow 2018-03 tax refunds 8870800
Reliance Income Statement 2017-03 revenue from operations 321567660000
.
.
.
.
and so on.
What are the ways I can achieve this with least effort ? Yes there are around 75,000 such files over which the same transformation will happen.
Thanks in advance.
Bookmarks