Joining a new table to a previously loaded table

[vstone]

For example -

Table A:

Load

colA

colB

From destination

Table B:

Load

colA

colB

From destination

How can I join Table B to Table A? I can't load Table B before Table A because Table B uses columns in Table A to create calculated fields in the dle. I know I can do a right join here, but I need Table A to be the one that is being joined to because i have many calculated measures and kpis that use Table A. That's also the same reason I can't create a new table to do the join - the join has to be onto Table A, and Table A has to be loaded first, followed by Table B being loaded.

[Prashant_Naik · Accepted solution]

Hi,

You can create a common key between both the tables and left join on the basis of that key.

Hope this helps.

Regards,

Prashant