Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
caseyjohnson
New Contributor III

Blending tables ... generate a new field

Hoping someone can help me with this. I would like to see how to join/display table info via a couple of fields from multiple tables. Short version is I need the Table B gen_name field to generate based on the matching model_id fields ..... IF the Table A model_year is between the gen_start_year and gen_end_year.

example: IF (model_year >= gen_start_year & <= gen_end_year, display gen_name)

Table A:

LOAD

    model_id,

    model_year,

    etc....

FROM ...

Table B:

LOAD

    model_id,

    gen_start_year,

    gen_end_year,

    gen_name

FROM ...

I'm assuming that this process would be best performed in the load editor and I would appreciate seeing what that may look like. I'm still a little unsure where to put additional scripts in the editor so if you could show what the entire script (tables & all) looks like, that would really help me out.

Tags (1)
3 Replies

Re: Blending tables ... generate a new field

caseyjohnson
New Contributor III

Re: Blending tables ... generate a new field

Thank you for the information. It seems to be the right approach, but I can't seem to get it to work.

Re: Blending tables ... generate a new field

May be we can help if you are able to provide a sample

Community Browser