Concatenating (and NOCONCATENATE) in Qlikview 3

concatenateBarry Harmsen over at Qlikfix put together a nice post about the CONCATENATE script function, and that got me onto other posts that clarify and give examples on the proper use of this powerful feature. From Barry’s post:

One of the subjects I often see new QlikView developers struggle with, especially those without prior database experience, is merging data from different tables. In this series of two posts I will explain how to use the CONCATENATE and JOIN prefixes to bring together data from multiple tables. Simply put, the CONCATENATE prefix lets you add rows to a previously loaded table, while the JOIN prefix lets you add columns to a previously loaded table.

The QlikviewNotes blog also did a nice job on the differences between JOIN and CONCATENATE.

Understanding Join and Concatenate: The Qlikview script functions JOIN and CONCATENATE can sometimes be used to tackle the same problem, but there are important differences that should be understood.

And finally, QlikviewMaven did a nice post on NOCONCATENATE. Don’t let Qlikview auto-concatenate for you — put the power back in your own hands!

This is a mistake I make every once in a while and it always puzzles me for a few minutes before I figure out what happened. In the loadscript, if you load data from several sources and use exactly the same field names then QlikView will automatically concatenate the data from the second source onto the table created for the first source. It does this unless you specify the keyword NOCONCATENATE.

  • Dhananjay

    Hi There,

    This is dhananjay,i am new in qlikview so can you tell me the how Concatenating in two different table fields.

  • Pingback: Concatenate & NoConcatenate Table Operators in QlikView Script()

  • Rick

    Hello Matt,

    I have the following in my inline script:

    T1:
    LOAD * INLINE [
    F1, F2
    a, 1
    a, 2
    b, 3
    c, 4
    ];

    T2:
    LOAD Distinct * Inline [
    F1, F2
    a, 1
    b, 3
    b, 3
    c, 4
    ];

    How would I be able to view the following through the Table Model?

    T1
    F1, F2
    a, 1
    a, 2
    b, 3
    c, 4
    a, 1
    c, 4
    b, 3

    Thank you,

    Rick

Follow

Get every new post delivered to your Inbox

Join other followers: