Combine three table into one

[prma7799]

Dear All,

I have three table in the attachment but I dint understand that How can i create these three table into one table.

I want to find out that which therapy have which brand etc.

PFA...

Thanks

[Chanty4u]

hi

load all 2 qvds and  replce below code

Thearpy:

LOAD Therapy_Code &' _'& '_' &Brand_Name & Brd_code as Newcode,

     Therapy_Name

FROM

DIMQVTherapy.qvd

(qvd);

[prma7799]

code is not work....

[Chanty4u]

can u share ur third qvd...

bcz ur attached qvd has duplicate

can chk and attach 3qvds

[prma7799]

tresesco‌,Avinashelite‌,  jaganmohanrao, sunindia‌,

Please look into this.

[prma7799]

Please check above.

[MayilVahanan]

Hi

From your data, there is brd_code is null for N_therapy.

N_Thearpy	Brd_code
Alimentry Systems
Allopathy
Analgesics & Antipyretics
Anti-Haemorrhagics
Anti-Helminthic
Anti-Infective
Anti-Malarials
Anti-Obesity
Antidiabetic
Cardiovascular System
Dental
Dermatology
Exports-Dossiers
Exports-Regulated
Gynaecology
Hormones
Musculo-Skeletal Disorders
Neurology
Nutrition
Oncology
Opthalmic/Ent
Respiratory Systems & Anti-Allergy
Urinary

What is the expected output? N_Brand and Brand_Name has same data.. What is the purpose of "Bnd" qvd. Could you able to explain in details

[Chanty4u]

I think there no field values   Brd_code,

Please chk it and update

[prma7799]

Hi MayilVahanan‌

Thanks for your reply ....

In the attached I have one pivot table I want output like that whenever I take dimension as Therapy I want show all brands respect to that therapy.

I know there is no any relation between Therapy n brand but I have to do association with them.

Please do the needful.

[florentina_doga]

try this

ITEM:

LOAD Item_Code,

     Brd_code,

     N_Brand,

     Dept_code,

     N_Dept,

     Seg_code,

     N_Thearpy,

     Div_code,

     N_Division

FROM

ITEMDIMENSIONS.qvd

(qvd);

left join (ITEM)

LOAD Brand_Code  as Brd_code,

     Brand_Name

FROM

DIMQVBrand.qvd

(qvd);

is not necesary table Thearpy.