Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Regarding the Concatenation

Hi friends,

I hve attached the screenshot of the data model  i need to concatenate the  tables  MOF_COMM_NO_RANGE and  VIEW_COMPLETE_FZ_STRING , so pls anyone suggest how can i achieve this.  The unique  FIELD is commssion number.

Thanks & Regards,

Nikitha Jain M.B

5 Replies
AbhijitBansode
Specialist
Specialist

Nikitha,

From your attachement, I dont see a common filed 'commssion number' between tables MOF_COMM_NO_RANGE and  VIEW_COMPLETE_FZ_STRING.

It is common between these two tables:

POA and  VIEW_COMPLETE_FZ_STRING.

Why do you want to concatenate these tables?

Regards,

Abhijit

Not applicable
Author

hi

to concatenate the  tables  MOF_COMM_NO_RANGE and  VIEW_COMPLETE_FZ_STRING.

write

rowno() as key

in both table.

vikram_patro
Contributor III
Contributor III

Concatenate is same as PL-SQL "Union". To concatenate 2 tables, make sure that common fields have same field names.

Vikram

sujeetsingh
Master III
Master III

Just ensure that both tables should have common columns.

See the sample i have done both Join and Concatenation .

See what you want for your model.

Not applicable
Author

Hi,

as per my knowledge, %_MOF_KEY is the Commission number.

but you have to explain y u want to concatenate or join. without having any info not easy to design the data model structure.