2 Replies Latest reply on Jul 31, 2018 10:52 AM by Sai Sri B

    Changing the data source

    Sai Sri B

      Hi Team,

       

      I have created a dashboard by pointing to the .xlsx (let's say XLSX1) which has column titles like A, B, C ......Z.

      Now I want to map the dashboard to another .xlsx (let's say XLSX2) which has different column titles like AA, BB, CC....ZZ

       

      Can you please guide me how to point make my dashboard pointed to XLSX2?

        • 1. Re: Changing the data source
          Simon Runc

          hi Sai,

           

          So without getting into hacking around in the XML, you'll need to first switch the data source, by using "Edit Data Source" (if the source is the same...eg. Excel to Excel), or will need to bring in the new datasource and then choose "Replace Data Source" (From the data top menu) if it's a different type (eg. Excel to MS SQL).

           

          This will get you part way, but as he column names are different everything will break...you can then use "Replace Reference" column by column, to replace A with AA (for example)

           

          Ideally you'd have the same column names in both sources, then you can just use the options above.

           

          I've attached a .gif showing the replace reference process.

           

          Hope that helps

          • 2. Re: Changing the data source
            Sai Sri B

            This is what I was looking for Simon. Thank You.