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

Join tables with a inputfield

Hello all,

I have two tables, one with the month numbers and one with the stores. I want to create a third table with two columns with adding a inputfield to put the number of sales. Is it possible?

Capture.PNG
Many thanks

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Join tables with a inputfield

First join the tables, then create a new table with a resident load and add the input field:

Temp:

LOAD * FROM ...table1...;

JOIN(Temp)

LOAD * FROM ...table2...;


INPUTFIELD NoOfSales;


Result:

LOAD *, 0 as NoOfSales RESIDENT Temp;


DROP TABLE Temp;


talk is cheap, supply exceeds demand
4 Replies
MVP & Luminary
MVP & Luminary

Re: Join tables with a inputfield

First join the tables, then create a new table with a resident load and add the input field:

Temp:

LOAD * FROM ...table1...;

JOIN(Temp)

LOAD * FROM ...table2...;


INPUTFIELD NoOfSales;


Result:

LOAD *, 0 as NoOfSales RESIDENT Temp;


DROP TABLE Temp;


talk is cheap, supply exceeds demand
Not applicable

Re: Join tables with a inputfield

Thank you for the precise answer.

Not applicable

Re: Join tables with a inputfield

Is it a real problem if joining tables creates a circular join?

MVP & Luminary
MVP & Luminary

Re: Join tables with a inputfield

Yes.


talk is cheap, supply exceeds demand