join inventory and sales workbooks

[vikas_nandanwar]

Hi,

I have one inventory excel with Date, A, B, C, D, E columns,

Sales excel with Date, C, F, G,L columns,

How do i link both excel in one?

Thanks,

Vikas

[Anil_Babu_Samineni]

Please go through Booklet or Workplace of reference sheet.

Ans - Simply rename it and use Join for 2 tables

[vikas_nandanwar]

please elaborate

[Anil_Babu_Samineni]

Here we go

Load Date, A, B, C, D, E from Excel1;

Join

Load Date, C as A, F as B, G as C, L as D from Excel2;

[neha_shirsath]

The data level of both excel is same?

Means the fields A,B,C,D,E and C,F,G,L has same data? if yes, then you can simply rename and join both.

[shraddha_g]

Try

Load Date &'-'& C as Key,

Date as Inventory_Date, A, B, C as Inventory_C, D, E

From Inventory;

Join

Load Date &'-'& C as Key,

Date as Sales_Date, C as Sales_C, F, G,L

From Sales;

[vikas_nandanwar]

No Data in A, B, C, D, E, F, G, L has different data.

Only Date column and Column C has same data

[neha_shirsath]

Try this-

Inventory1:

LOAD * Inline [

Date , A, B, C, D, E  ];

Sales1:

LOAD * Inline [

Date, C , F, G,L

];

Inventory:

Load Date &'-'& C as Key1,

Date , A, B, C, D, E Resident Inventory1; drop Table Inventory1;

Sales:

Load Date &'-'& C as Key2,

Date, C , F, G,L Resident Sales1; DROP Table Sales1;

LinkTable:

Load Date &'-'& C as Key1,

          Date as LinkDate,

          C as LinkC

resident Inventory;

concatenate

Load Date &'-'& C as Key2,

          Date as LinkDate,

          C as LinkC

resident Sales;

Drop Fields Date, C From Inventory;

Drop Fields Date, C From Sales;

[vikas_nandanwar]

no this doesn't work

[shraddha_g]

can you share sample data?