topic Re: Joining Tables in App Development

Joining Tables

evansabres — Thu, 07 May 2020 17:13:46 GMT

I have two tables, 'Post' and 'Metrics'

The fields that are in 'Post' are brandID, mediaID and linkID.

Metrics has many fields, but a common field is linkID. The tables are currently associated via that field, however I would like to introduce the field brandID into the table Metrics.

Is this possible via a join or another method or not possible at all?

Re: Joining Tables

dplr-rn — Thu, 07 May 2020 17:34:14 GMT

Joins in qlik are very similar to sql with slightly different syntax. the join is done on the fields common between the tables

you can either use join see below

https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/Scripting/combine-tables-join-keep.htm

or applymap (this works when 1 new column is needed)

Re: Joining Tables

IamAlbinAntony — Thu, 07 May 2020 17:35:10 GMT

You can use apply map to get the brandID into the table Metrics using linkID.

And if you are loading this 2 table into qlik then concatenate both linkID&brandID as a key.

Re: Joining Tables

evansabres — Thu, 07 May 2020 18:02:44 GMT

Thank you, can you please elaborate on how Apply Map work work in this scenario?

Re: Joining Tables

dplr-rn — Thu, 07 May 2020 18:23:54 GMT

rough script

brandmap: mapping load linkID, brandid ; your sql for Post load column-a, column-b,.. linkID, applymap('brandmap',linkID) as brandid ; your sql for Metric