Hi, I have to tables which should have exactly the same data. I need to find the columns that don’t match base on the same ID. See examples below. Any idea what's the best way to complete t...
Hi everybody, Hope you are doing well 😎 I load in my script Two tables, one with the id of the last mont and the other with the id of the current month like this : I want to c...
Hi All, I have two columns getting the data from two different sources ( ftp and oracle database) . I am getting those two columns data in the sheet. I want to compare those two columns data v...
Hi experts,
I would like to compare yeears' sellings for months.
For example i am going to choose January and want to see in this table how was it like in 2021 and 2022.
A...
Good afternoon Qlik Developers, I have two tables with partially matching data. Table 1 is "all" data and Table 2 has "partial" data. The ideal output would be to return all non-repeated data as i...
Hi All, In the below mentioned table ,I want to compare SQ number row by row. For eg: first row of sq number is 19200002 then the first row of above column should show No because sq number d...
Team, I am using the below code logic to compare the two fields.It is working with small data but whenever using the huge value of data it is getting stuck.could you please suggest me an a...
Hello, All codes in Table A are not necessarily present in table B I would like to add a new type of field flag contennant EMC 'for the codes in both tables and' NO EMC 'for others. Thank you f...
Hello, I was hoping to get some help from experienced users. I have reviewed multiple posts and have been trying to get the difference between the sums of 2 fields on different tables, but c...
...earn more about it. I would like to compare the 2 tables in excel spreadsheet but pull the records that does not match each according to primary key. Header 1 Header 2 Header 3 Header 4 Header 5...