topic Re: loading in Developer

loading

madji — Fri, 21 Jul 2017 12:32:25 GMT

I am new in PW BI,

Could you help me?

For exemple ( simple) I have 2 tables loading:

A	B
1	1
2	2
3	3

A	D
2	5
3	6
4	7

I try to get tables 3 in script:

A	C ( B and D)
1	1
2	2
2	5
3	3
3	6
4	7

How can I get it?

Thanks!

Re: loading

Eric_Zhang — Mon, 24 Jul 2017 05:52:47 GMT

@madji

You could either try PowerQuery or DAX, see below sample and attached pbix file.

let
    SelectAndRenameColumnsFromTable1 = Table.RenameColumns(Table.SelectColumns(Table1,{"A","B"}),{"B","C"}),
    SelectAndRenameColumnsFromTable2 = Table.RenameColumns(Table.SelectColumns(Table2,{"A","D"}),{"D","C"}),
    CombineAboutTwo = Table.Combine({SelectAndRenameColumnsFromTable1,SelectAndRenameColumnsFromTable2})
in
    CombineAboutTwo

combinedTableInDax =
UNION (
    SELECTCOLUMNS ( Table1, "A", Table1[A], "C", Table1[B] ),
    SELECTCOLUMNS ( Table2, "A", Table2[A], "C", Table2[D] )
)

Re: loading

madji — Mon, 24 Jul 2017 08:36:10 GMT

@Eric_Zhang

Thanks,

But If I have in first table - 6 columns and in second table - 8

6 columns are similar.

Are there working for only two columns?

Re: loading

Eric_Zhang — Wed, 26 Jul 2017 02:00:40 GMT

@madji wrote:

@Eric_Zhang

Thanks,

But If I have in first table - 6 columns and in second table - 8

6 columns are similar.

Are there working for only two columns?

@madji

You can just add more colulmns in the SELECT columns in my previous post.