Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
cabhijit
Not applicable

Re: Regarding the Concatenation

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

Re: Regarding the Concatenation

hi

to concatenate the  tables  MOF_COMM_NO_RANGE and  VIEW_COMPLETE_FZ_STRING.

write

rowno() as key

in both table.

vikram_patro
Not applicable

Re: Regarding the Concatenation

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

Vikram

sujeetsingh
Not applicable

Re: Regarding the Concatenation

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

Re: Regarding the Concatenation

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.