Merge/Concatenate/Join table Approach

[vimalthehero]

Hello Qliksense Experts,

im looking for a simple logic to merge two table and expected result is given below.

is it possible to acheive it using exisitng join or concatantate commands is my doudt,

Please suggest how can i acheive it.

here is the logic I'm working on and trying to find solution:

Table1:

ID	Name	Title	Age
2	Paul	Technical Support Engineer	22
4	Janne	IT Specialist	27
1	Wladimir	Team Lead	31
3	Mark	Customer Support Engineer	40

Table2:

ID	Name	Title	Age
2	Paul	Technical Support Engineer
4	Janne	IT Specialist	27
1	Wladimir	Team Lead	31
3	Mark		40

Expected Result after merging:  (Table1 & Tabel2)

ID	Name	Title	Age
2	Paul	Technical Support Engineer	22
4	Janne	IT Specialist	27
1	Wladimir	Team Lead	31
3	Mark	Customer Support Engineer	40

Code i tried to achieve above result: ( not worked)

table11:
Load * Inline [

ID, Name, Age, Title

1, Wladimir, 31, Team Lead

2, Paul, 22, Technical Support Engineer

3, Mark, 40, Customer Support Engineer

4, Janne, 27, IT Specialist

];

Concatenate (table11)

Load * Inline [

ID, Name, Age, Title

1, Wladimir, 31, Team Lead

2, Paul, ,Technical Support Engineer

3, Mark, 40

4, Janne, 27, IT Specialist

];

[Lisa_P]

I think your sample data is not a good example to follow as you already have what you want in your first table. What is the scenario you are trying to solve ?

[vimalthehero]

good observation 🙂

just make one item of a column in first table blank it will be be good example or else please use this.

my aim is to merge all the blank data of each table to merge together and fill the blank data to appropriate values.

table11:
Load * Inline [

ID, Name, Age, Title

1, Wladimir, 31

2, Paul, 22, Technical Support Engineer

3, Mark, 40, Customer Support Engineer

4, Janne, 27, IT Specialist

];

Concatenate (table11)

Load * Inline [

ID, Name, Age, Title

1, Wladimir, 31, Team Lead

2, Paul, ,Technical Support Engineer

3, Mark, 40

4, Janne, 27, IT Specialist

];

[vimalmanavalan]

i think, i found an easy solution for my problem,

after concatenate the two tables, just use maxstring or max for those column where we need to remove blank values with appropriate/filled data ( group by name and ID).

Thanks a lot 🙂