Union Sources in Query
답변함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.
-
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 Turn0댓글을 남기려면 로그인하세요.
댓글
댓글 1개