topic Re: Regarding the Concatenation in QlikView

Regarding the Concatenation

Fri, 21 Jun 2013 07:20:49 GMT

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

Re: Regarding the Concatenation

AbhijitBansode — Fri, 21 Jun 2013 07:28:10 GMT

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

Re: Regarding the Concatenation

Fri, 21 Jun 2013 07:29:01 GMT

to concatenate the tables MOF_COMM_NO_RANGE and VIEW_COMPLETE_FZ_STRING.

write

rowno() as key

in both table.

Re: Regarding the Concatenation

vikram_patro — Fri, 21 Jun 2013 07:32:31 GMT

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

Vikram

Re: Regarding the Concatenation

sujeetsingh — Fri, 21 Jun 2013 07:37:41 GMT

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.

Re: Regarding the Concatenation

Sun, 23 Jun 2013 10:49:52 GMT

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.