Skip to main content
  • EN

Hello Guys

we get a significant number of excel sheet and we need to push them to the DB schema attached is a sample data and also the output we want any one have an idea

Thanks

What you want is transpose. Study this excellent article. Only additional thing you need to do is rename the empty rows / columns to city & year but that could be automated as well. Aggregator, validate vales, in integer then year, else city.

Reply


Community Stats

30,117
Posts
114,313
Replies
37,747
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.