|
A partire da gennaio 2021, i tipi di file classici non potranno più essere utilizzati. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

Union Sources in Query

Con risposta
Richiedi una demo

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

Commenti

1 commento

Data Voti
  • 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

Accedi per aggiungere un commento.