I have 138 Columns with 365 days are rows. Each day any of 138 columns may have some numeric value, I want to create a view so that I can filter or search sales done on specific item (column value) for the year etc. You need to connect to my desktop for accessing the database.
New View should have 3 columns like Date Value Sale Amount
Value Column will have the values of all original column names found in the table.
Example say if original column is like this:
Date program1 program 2
2/2/2018 1000
3/3/2018 1000
4/4/2018 200 200
I want new View to be like this
Date Value Sale_amount
So that I should be able to generate report like show me all sales generated from Program1 etc
Hi,
Hope you are doing great. I am data warehousing certified professional and i have work experience of world's Top Data warehouse company "Teradata" .I can easily accomplish this [login to view URL] feel free to contact if you find my bid suitable for this [login to view URL] forward to your reply.
Regards,
Adnan Haider
₹850 INR trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
7 freelancer chào giá trung bình ₹1.093 INR cho công việc này