topic Re: Mismatch report in QlikView

Mismatch report

Sivavasam1 — Sun, 07 Aug 2022 17:54:43 GMT

I have to tables with systemId & GroupId two columns in one table1 , systemid & GroupId both in single column for second table2 . Can anyone help me pls I need to join first.

Table 1 Table 2

Column 1|Column 2 column 1

systemId | GroupId systemId& GroupId

123 23453 123

123 23454 23453

123 23455 23454

23455

Re: Mismatch report

Nicole-Smith — Mon, 08 Aug 2022 16:18:15 GMT

Would something like this work? It should make your join fields between the two tables both be concatenated together so that it joins properly.

All:
LOAD [Column 1] (enter list of other columns wanted from Table 2 here)
FROM Table2;

LEFT JOIN (All)
LOAD [Column 1] & [Column 2] AS [Column 1] (enter list of other columns wanted from Table 1 here)
FROM Table1;

Re: Mismatch report

Sivavasam1 — Sat, 13 Aug 2022 08:34:50 GMT

Thank you for your response....

I have tried but it's not working....groupids not getting.... showing null value ...Table1 and Table 2 are from two seperate databases...Table1 column 1 & column 2 has some relation but Table2 groupids generating in same column

Re: Mismatch report

PrashantSangle — Sat, 13 Aug 2022 09:11:11 GMT

Hi, Can you explain your query with sample data and expected result?

Provide your expected result too.

Regards,

Prashant Sangle

Re: Mismatch report

Sivavasam1 — Sat, 13 Aug 2022 14:19:16 GMT

One is SAP database Table 2 & second Table 1 is from odbc SQL database... Every day data pushing from Odbc to SAP ...for each system I'd there is a children group I'd will generate individually...like I mentioned above in seperate group I'd column..but in SAP individual group I'd generating in the same column . I need to display result like as table1 with system I'd mapping. Result look like as table1 ... should reflect in table 2