Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

Union Sources in Query

Udzielono odpowiedzi
Zamów wersję demonstracyjną

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

Komentarze

Komentarze: 1

Data Głosy
  • 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

Zaloguj się, aby dodać komentarz.