Creation of Key field

[Santhoshmdm]

Hi,

I am new to Qliksense, maybe somebody can help me out with this question.

I have two tables where there is no common fields and I need to join both the tables together. Concatenate is not an option where I will have blank records for the newly added fields for the existing records in the first table. Is there a way I can create a common field where I can use the same for join.

Example :

Table 1:

Order_Number,

Batch_Number

Resident X;

Table 2:

Analysis,

Test_Number

Resident Y;

Thanks in advance

[Raja2022]

I am not sure why you want to join two table when you do not have a common field. But please look into the link below and see if that helps to understand better:

https://community.qlik.com/t5/QlikView-App-Dev/How-to-join-two-tables-without-common-Key-Field/td-p/...