That's also normal;
HelpSitePort = 80 is repeated but that normal; why?
because we have HelpSitePort = 80 linked to ConfulencePort =80
HelpSitePort = 80 linked to ConfulencePort =443
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 !
when u join all u table, the resulting one would be one final table;
now try to adapt this to ur script:
load *, if(confluencePorts=HelpsitePorts,1,0) as Flag Inline [
confluencePorts , HelpsitePorts
80 , 444
Load confluencePorts AS Alert_confluencePorts where Flag=0;
Load confluencePorts, sum(Flag) as Flag Resident YourTable Group by confluencePorts;
drop Field Flag From YourTable;
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.