Mismatch report

[Sivavasam1]

Hi 

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

[Nicole-Smith]

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;

[Sivavasam1]

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 

[PrashantSangle]

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

Provide your expected result too.

Regards,

Prashant Sangle

[Sivavasam1]

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