Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

How To Link Two Different Sets of Files

Hi,

I am facing a problem in linking two different sets of Files

I am having one file which contains Premium related information and another file contains complaints information.  Both the files we can link through Channel, AVP and VP..but after linking these Two files I will be getting  out-put like below..which I not want..

Out-Put 1)...If I select AVP and VP names from combine_1 file

NewAVPNewVPPremiumComplaint
2776005
--01
JamesMehandele100001
JosephAshu100001
SameerJoshi100001
NiteshPatel120001
RimaNancy2356000


Out-put 2)..
If I select AVP and VP names from combine file


AVPVPPremiumComplaint
2776005
RameshShetty01
JamesMehandele100001
JosephAshu100001
SameerJoshi100001
NiteshPatel120001
--2356000

so if you notice in either of these two tables VP and AVP name remains blank. But,I want name should appear either I will select AVP and VP  from combine file or NewAVP and NewVP from combine_1 file.

How I can achieve this...Please help.

Thanks in advance.

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Try this:

A:

LOAD Policy_no AS New_Policy,

     Premium,

     Year,

     Month,

     Channel,

     AVP,

     VP,

     Channel & '|' & AVP & '|' & VP as link     

FROM

[combine.xlsx]

(ooxml, embedded labels, table is Alernate);

B:

LOAD Policy_No,

     Complaint_No,

     Complaint_Description,

     Channel,

     AVP,

     VP,

   Channel & '|' & AVP & '|' & VP as link   

FROM

[combine_1.xlsx]

(ooxml, embedded labels, table is Alernate);

LinkTable:

LOAD DISTINCT

  link,

  Channel,

  AVP,

  VP

Resident A;

LOAD DISTINCT

  link,

  Channel,

  AVP,

  VP

Resident B;

DROP Fields Channel, AVP, VP FROM A;

DROP Fields Channel, AVP, VP FROM B;

EXIT Script


talk is cheap, supply exceeds demand
Highlighted
Creator III
Creator III

That's Great...It's working.

Thanks a lot..