Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deere2013
Contributor III
Contributor III

join based on concat of two fields

I have a data set where I want to join to another data set by the concat of two fields.

example

MATERIALSAP REV ROWconcat
123456A123456A

so the concat field is what I would join the other table with.  I was thinking that I do this in the script upon the load...rather than load it twice

1 Solution

Accepted Solutions
avinashelite

Hi

Try like this

Load

MATERIAL&SAP REV ROW as field_name

from tablename

View solution in original post

3 Replies
avinashelite

Hi

Try like this

Load

MATERIAL&SAP REV ROW as field_name

from tablename

View solution in original post

simenkg
Specialist
Specialist

You create a composite key in your script:

Load *, MATERIAL & [SAP REV ROW] as %ConcatKey Inline [

MATERIAL, SAP REV ROW

123456,A

];

puttemans
Specialist
Specialist

Hi there,

The script should look like this:


Table 1:

load *,

     MATERIAL&SAP REV ROW as linkname

FROM....

noconcatenate

Table 2  :

Load *,

    MATERIAL&SAP REV ROW as linkname

FROM....

(right/left/...)Join

Load *

Resident Table1;