Table 1 and Table 2 and Table 3 Single Table

[techvarun]

Hi All

   This May be a silly question

I have three tables

A

State

Region

Week

Sales

B

State

Statetxt

C

Region

RegionTxt

I need the result table

State

StateTxt

Region

RegionTxt

Week

Sales

Thanks

Varun

[simenkg · Accepted solution]

A:

Load * from A.qvd (qvd);

Left join (A)
Load * from B.qvd (qvd);

Left join(A)

Load * from C.qvd (qvd);

[manojkulkarni]

Use ApplyMap,

quick applymap example