Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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?

Highlighted
Not applicable

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


Highlighted
Employee
Employee

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
Highlighted
Not applicable

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.

Highlighted
MVP
MVP

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.

Highlighted
Not applicable

Apologies, I missed double quotes there .

Highlighted
Creator III
Creator III

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,