Alter/Modify workbook data after importing from Data link


1 comment

  • Alan Mark

    Hi Thyagarajan,

    Source sheets are, by intended design, read only.  The only way to get different data is to change it in the data source itself directly, then re-import.

    However, it would seem that you have an underlying concern that's driving this question.  I think it may be that you are concerned with extra HDFS storage or possible performance penalties due to having a new sheet.  To avoid both of these types of problems, during the save step simply deselect the source sheet from being 'kept' and only select the new duplicate sheet where you've modified the data using formulas.

    This topic and some other directly relevant subjects are covered in our Analyst Basics 1 class.  You'll want to check out Datameer University to get access.

    Let me know if you've got any other questions,


    Comment actions Permalink

Please sign in to leave a comment.