Discussion Board for collaboration on QlikView Scripting.
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
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?
to concatenate the tables MOF_COMM_NO_RANGE and VIEW_COMPLETE_FZ_STRING.
rowno() as key
in both table.
Concatenate is same as PL-SQL "Union". To concatenate 2 tables, make sure that common fields have same field names.
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.
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.