|
Klassiska filtyper är inte längre tillgängliga för användning från och med januari 2021. Du kan överföra dina klassiska filer eller ladda ner en PDF. Läs mer

Union Sources in Query

Besvarat
Begär 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

Kommentarer

1 kommentar

Datum Röster
  • 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

Du måste logga in om du vill lämna en kommentar.