Is there a way to change cell(field) in the excel from the sheet?
example:
i am getting from the excel customer name but i want from the sheet add application for each customer (if needed).
i can add excel file with customer name and application but since i am getting new customers everyday the appication should be something i can add from the sheet - how to do that ?
If I understand correctly, you need to add a value (application) to some of the customers you import every day from Excel. You would like to do this directly in the Qlik Sense table.
I don't think this is possible. It is much better that the modification is done in the Excel file and that you then run a reload to import the new data in Qlik Sense from Excel.
You may schedule some recurring reloads to do this.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂
If I understand correctly, you need to add a value (application) to some of the customers you import every day from Excel. You would like to do this directly in the Qlik Sense table.
I don't think this is possible. It is much better that the modification is done in the Excel file and that you then run a reload to import the new data in Qlik Sense from Excel.
You may schedule some recurring reloads to do this.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂
