自 2021 年 1 月起,经典文件类型不再可用。您可以转换经典文件或下载 PDF 文件。了解更多

Union Sources in Query

已回答
0

评论

1 条评论

  • 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

请先登录再写评论。