topic Re: Joins or concatenatiom in App Development

Joins or concatenatiom

Bharathi09 — Wed, 04 Jan 2023 13:07:18 GMT

Hi All,

I have students data in two files

which have ID, Name,Contact like this

ID field is common in both the files

I need to create visuals based on two files

What is best to use joins or concatenation

PLease help

Re: Joins or concatenatiom

pedrobergo — Wed, 04 Jan 2023 13:14:06 GMT

Hi @Bharathi09

Just create an app and using Data Load Manager, upload the two files, If both fields have same name Qlik will associate tables, then just create your visuals.

Please, access the tutorial to learning basic from Qlik Sense.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/Tutorials.htm

[],

Pedro

Re: Joins or concatenatiom

rui24 — Wed, 04 Jan 2023 14:14:53 GMT

hi Bharathi09

You can just add the 2 files and set the ID field as primary key of these 2 tables and they automatically link between each other

Re: Joins or concatenatiom

Bharathi09 — Thu, 05 Jan 2023 15:51:24 GMT

Actually I have 2 data sets in which data is different in two datasets some column names are same but different data ,
I also have 3rd dataset
I loaded this 3 datasets in QS
I need to merge this 3 tables and one more thing is that I have location column in 3rd table which I need to bring it up in previously loaded table

Solution please

Re: Joins or concatenatiom

pedrobergo — Fri, 06 Jan 2023 11:51:22 GMT

Hi @Bharathi09

I think you need to watch Tutorials then you ´ll concatenate or join the 3rd table using Data Load Manager or Loading Editor.

Take a look on help how to do that: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/managing-data.htm

[],

Pedro