Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to copy field of one table to other table??

Hi all,

I just want to know if its possible or not...!!

See there is a field called QUANTITY in Sales Table and

There is another field called Orderprice in Dealers Table

Now If I want the QUANTITY Field to Dealers Table what i have to do?? Like i want all the details to be used which are in QUANTITY field..!! I want access between Quantity and Orderprice...

Help me out..

Thank you ...!!

Keep smiling

2 Replies
MVP
MVP

Re: How to copy field of one table to other table??

I assume that your tables are somehow linked to each other, e.g. by a common field ProductID (anyway, it would be helpful if you could describe your data model a little closer, to avoid our wild guessing).

There are lots of different solutions to your problem, like

a) JOIN the tables by common field

b) use a MAPPING LOAD and APPLYMAP() function

c) use LOOKUP() function in your load to lookup values from a different table

d) just do nothing (besides having the tables linked by ProductID) and do the calculation in the frontend

To select the right solution will depend on what you exactely want to do, so some small sample app attached to this thread or some sample lines of input data togehter what you expect as outcome would help us to help your.

Regards,

Stefan

Not applicable

Re: How to copy field of one table to other table??

Hi Qlikie..

Thank you so much...

Ur reply helped me to understand..!!..

Here's the attachment...

Thank you

Community Browser