|
Los tipos de archivo clásicos dejarán de estar disponibles a partir de enero de 2021. Puedes migrar tus archivos clásicos o descargar un PDF. Más información

Union Sources in Query

Respondida
Solicitar demostración

Hello! I am attempting to create a query using data from two tables. I would like to add the new rows based on position (union the two sources to add rows instead of joining based on a key). Is this possible?

I tried using the UNION function in the SQL editor, but I was still receiving an error message stating that a relationship is needed. Can anyone advise on the best way to go about this? There are no key columns in either of the tables.

0

Comentarios

1 comentario

Fecha Votos
  • Wade Hays

    Hi Talia,

    You should be able to UNION the data in SQL mode. Your query needs to be something like:

    SELECT line_items, nii_reporting_product, time, reporting_plan_and_actual_headers, m1_miscellaneous_investment_income_types, nii_reporting_company, input_currency_usd, gaap, refresh from "Misc NII Table_TABLE_ID"
    UNION ALL
    SELECT line_items, nii_reporting_product, time, reporting_plan_and_actual_headers, m1_miscellaneous_investment_income_types, nii_reporting_company, input_currency_usd, gaap, refresh from "DBOD Misc NII Table_TABLE_ID"

     

    You will want to replace the table id info and alias the column names. You may also want to consider using one table, and tag the datasets on import.

    Regards, Wade
    --
    Wade Hays - Tower Turn

    0

Iniciar sesión para dejar un comentario.