CR XI - i have a excel doc that I am uploading that was created in Cognos and exported to excel. When it gets export there are mutliple sheets/tabs in the xls field. I upload it and I get a folder under the database fields for each sheet/tab (5).
Is there a way to combine all 5 into one folder - I have tried but cannot seem to figure it out. I need to pick and choose certain fields from each of the 5 folders. When I do it the old fashion way it does not work correctly.
Thanks in advance for any responses