Forum Discussion

achrafkasmi's avatar
achrafkasmi
Icon for Helper I rankHelper I
3 years ago

merge two tables on Directquery Mode

Hi,    I have two tables in DirectQuery mode: V_demandeStockD and V_tranStockD.   I want to merge the two tables , and adding a columns on V_demandeStockD to have the ItemCode and Dscriptio...
Need Help
Tips and Tricks
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago
Table =
UNION (
    SELECTCOLUMNS (
        V_demandeStockD,
        "ColumnName", [tablecolumn],
        .,
        .,
        .,
        "ColumnName", [tablecolumn]
    ),
    SELECTCOLUMNS (
        table2,
        "ColumnName", [tablecolumn],         
.,
.,
.,
"ColumnName", [tablecolumn]
    )
)

achrafkasmi  i hope this helpyou.