none
How to combine multiple queries in query editor and add calculated columns? RRS feed

  • Question

  • Hello,

    I have three queries that I want to combine in Query Editor so when I return data to my excelsheet, the data will be returned all at once. I have managed to make it work somewhat, even though I am not sure I am using the correct method. But I also want to have a number of calculated columns in between the returned columns. I can add new columns in the Excelsheet, but when I update my data, these new columns will go away.

    What is the correct way to combine queries ans calculated columns, so that everything will remain when updated?

    Thank you,

    //Peter


    • Edited by SPEHE Tuesday, June 2, 2015 8:36 AM
    Tuesday, June 2, 2015 8:35 AM

Answers

  • Hi Peter,

    you need to edit the table properties of the PQ-Output-table and check another box (Table Tools - Design - External Table Data - Properties - Preserve column....):


    Imke


    Tuesday, June 2, 2015 9:13 AM
    Moderator

All replies

  • Hi Peter,

    you need to edit the table properties of the PQ-Output-table and check another box (Table Tools - Design - External Table Data - Properties - Preserve column....):


    Imke


    Tuesday, June 2, 2015 9:13 AM
    Moderator
  • I was looking for that setting! Sweet!

    Thank you!

    //Peter

    Tuesday, June 2, 2015 9:18 AM