Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cdb
Former Employee
Former Employee

Joining two tables

Hi guys

I m loading two tables using "web file" connection method in Data load editor.

Capture.JPG

When I show them in table it comes like this ... If you can see one record is getting repeated ...number of times....Can some híne help solve this issue.

Capture.JPG

1 Solution

Accepted Solutions
OmarBenSalem

when u join all u table, the resulting one would be one final table;

now try to adapt this to ur script:

YourTable:

load *, if(confluencePorts=HelpsitePorts,1,0) as Flag Inline [

confluencePorts  ,  HelpsitePorts

80, 80

80 , 444

443,80

443, 443

200, 80

];

Test:

Load confluencePorts AS Alert_confluencePorts where Flag=0;

Load confluencePorts, sum(Flag) as Flag Resident YourTable  Group by confluencePorts;

drop Field Flag From YourTable;


result:

Capture.PNG

View solution in original post

8 Replies
OmarBenSalem

It's normal no?

if each ConfluencePort has many HelpSitePorts coming from multiple sources? No?

cdb
Former Employee
Former Employee
Author

Do you see the difference .... if I import them different tables it doesnt get repeated .... but get repeated if kept in one table ....how do I fix this?

Capture.JPG

OmarBenSalem

That's also normal;

for instance:

HelpSitePort = 80 is repeated but that normal; why?

because we have HelpSitePort = 80 linked to ConfulencePort =80

and

HelpSitePort = 80 linked to ConfulencePort =443

Capture.PNG


so when u just put as a list selection, the HelpSitePort  field; Qlik will show the disctinct existing values;

but when u put it in a table with the ConfulencePort , Qlik will link each combination of ConfulencePort -HelpSitePort  .


Hope this was clear !



cdb
Former Employee
Former Employee
Author

yes ,... I get it now ..but to get my app working ..I need  to check the confluence ports and Helpsite ports how do I do that ...

My do ..something like this .. If there is a port in confluence it should also be present in helspite port ..if it is not then I need to show it as a n alert

OmarBenSalem

let me try to understand;

if u have :

confluence ports  ,  Helpsite ports

80, 80

80 , 444

443,80

443, 443

200, 80


then u have a problem in the confulence Port 200; because u don't have Helpsite port =200 for the confluence one that is = 200

right?

cdb
Former Employee
Former Employee
Author

Right ..this I need to show in table for others to understand

OmarBenSalem

when u join all u table, the resulting one would be one final table;

now try to adapt this to ur script:

YourTable:

load *, if(confluencePorts=HelpsitePorts,1,0) as Flag Inline [

confluencePorts  ,  HelpsitePorts

80, 80

80 , 444

443,80

443, 443

200, 80

];

Test:

Load confluencePorts AS Alert_confluencePorts where Flag=0;

Load confluencePorts, sum(Flag) as Flag Resident YourTable  Group by confluencePorts;

drop Field Flag From YourTable;


result:

Capture.PNG

mdmukramali
Specialist III
Specialist III

Hi Swathi,

did you try omarbensalem‌ reply?

if Yes and your problem was solved then please close this thread by marking correct and helpful answers.

so it will helpful for others who are looking for similar solution.

if you have any issues then attach a sample file to have a look.

Thanks,

Mukram.