Data Arrangement

[akpofureenughwu]

Good morning everyone, I need help in arranging my data. If you look at the attached excel sheet, you will noticed that corporate has CAPEX n OPEX under it and different descriptions/item but when I load this file on QV, When I selected corporate, only CAPEX and one item on the description that is highlighted. Can u help with the arrange this data so that when I select corporate, CAPEX n OPEX will be highlighted and even all the descriptions under corporate will be highlighted as well. Thanks

[sunny_talwar]

Order is something like this:

1) OLEDB....

2) LOAD...

3) SQL SELECT ....

[akpofureenughwu]

Not working yet. See attachements

[sunny_talwar]

Field names to match exactly, I think the field might not be called Group and Description, is it?

[akpofureenughwu · Accepted solution]

Hey man, They are.. I used the exact field name. See attachement. The original excel sheet, I loaded it into the sql database environment.

[sunny_talwar]

Not sure what might be causing this. May be the data isn't correctly sorted for it to work as we would expect.

[akpofureenughwu]

So what is the next course of action sir?

[sunny_talwar]

Would you be able to share the application after running just the query (without the preceding load)