Excel Data Load Question

[danielnevitt]

Dear all,

I'm trying to load the attached file in Qlikview ('Original Data tab').

I would like to only load the range cells B4 to C58. I then need to change the row fields into the column headers ('New Data tab').

I've tried doing this using Enable Transformation Step, however it's not quite working correctly.

Any help is much appreciated.

Regards,
Daniel

[daines13]

I have a spreadsheet with "Yesterday" and "Today"'s raw data from Qlik Sense. I take the raw data from "Today" and replace "Yesterday"s data with it, then generate the new raw data on Qlik Sense, and paste it into "Today", every morning. I'd love to get this process automated using live data, but I'm not sure where to start at all. Is it even possible?