How to combine multiple csv files into one excel with multiple sheets

[jayaseelankrish]

Hi Exports, I need your help to complete this task. 

Scenario: I have two .csv file with few data. (Report1.csv & Report2.csv). I need to merge this two csv files into one excel with 2 sheets. 

I have attached the sample input csv and output excel file.

Kindly provide your inputs to achieve this. 

Thanks,

Jayaseelan 

[fosuzuki]

Do you really need to do it with Qlik Sense?  I don't think this is possible.

I guess it would be a lot easier to do this manipulation outside Qlik.

[jonathandienst]

Agreed, QlikSense is not the best tool for that.

If you are wanting to automate this process, I suggest you look for an Excel / VBA forum which should help you.

[jayaseelankrish]

Hi Fosuzuki,

Thanks for responding.  

Yes i need to achieve this with qliksense. In qliksense we able to execute some windows comments and powershell comments so using these logic, Is there any possibilities to achieve this?   

[jayaseelankrish]

Hi Jonty,

Thanks for the reply. 

I agree qliksense is not best tool to achieve this. but still i m looking for any possibilities.