Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Can someone please explain how Join and concantenation works here together.The code is below

  left join ([Total Cases Created])

 

  Load

    OrgID as TCC_OrgID,

    TicketID as TCC_TicketID

Resident [ticket];

 

  CONCATENATE ([Total Cases Created])

 

  Load

  "KNOX TicketID" as TCC_TicketID,

    'KNOX' as TCC_ServiceType

   Resident [BPST KNOX ];

7 Replies

Re: Can someone please explain how Join and concantenation works here together.The code is below

First the fields from the tickets table will be left joined into Total Cases Created table and then BPST KNOX table's field will be concatenated to Total Cases Created table. Does that answer your question or are you looking for something else?

Not applicable

Re: Can someone please explain how Join and concantenation works here together.The code is below

The field 'KNOX'  as TCC_ServiceType is not part of BPST KNOX will that be a problem?


Employee
Employee

Re: Can someone please explain how Join and concantenation works here together.The code is below

Dear Ankit,

   Join syntax is used to connect some tables with same structure or data manipulation in queries.

   Concatenate is used whe you want to create new fields in a existing table, avoiding two tables and centralizing data.

   Take a look on this two links:

Concat - script function ‒ QlikView

Combining tables with Join and Keep ‒ QlikView

   Please, mark the CORRECT/HELFULL comments to help us.

Ricardo Gerhard
OEM Solution Architect
LATAM
Not applicable

Re: Can someone please explain how Join and concantenation works here together.The code is below

Hi Ankit,

If 'KNOX'  as TCC_ServiceType is not the part of it , why do you write it in the load statement , It is syntactical wrong. Please remove it and run he script it will run fine.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

MVP
MVP

Re: Can someone please explain how Join and concantenation works here together.The code is below

Ankit Chaudhary wrote:

The field 'KNOX'  as TCC_ServiceType is not part of BPST KNOX will that be a problem?


No, you can create additional fields in your load statement, fields that are not part of your input table.

Here, you are creating a field named TCC_ServiceType with a constant literal value 'KNOX'

This is often used when concatenating multiple tables, to identify the source of data later on.

Not applicable

Re: Can someone please explain how Join and concantenation works here together.The code is below

Apologies, I missed double quotes there .

jayaseelan
Contributor III

Re: Can someone please explain how Join and concantenation works here together.The code is below

Hi Ankit,


       Consider you have table A, In that table you have a field as ID values 1,2,3. And the you have an another table B,

In that you have a fields ID, Name the corresponding value (1,2) and (Raj,Ram). If you LEFT JOIN these tables,you wil get following output.

                                      ID     Name

                                       1      Raj

                                       2      Ram

                                       3        -


Then assume you have table C in that fields ID and Name the corresponding values (4,5)and(Ravi,Raja). If you CONCATENATE with Table A you will get following output.

                      

                                       ID   Name

                                        1    Raj

                                        2    Ram

                                        3     -

                                        4    Ravi

                                        5    Raja

Please, mark the CORRECT/HELFULL comments to help us.



Thanks,