topic Re: Join tables with a inputfield in QlikView

Join tables with a inputfield

Wed, 29 Apr 2015 08:14:25 GMT

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?

Many thanks

Re: Join tables with a inputfield

Gysbert_Wassenaar — Wed, 29 Apr 2015 08:25:40 GMT

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;

Re: Join tables with a inputfield

Wed, 29 Apr 2015 08:27:39 GMT

Thank you for the precise answer.

Re: Join tables with a inputfield

Wed, 29 Apr 2015 08:33:06 GMT

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

Re: Join tables with a inputfield

Gysbert_Wassenaar — Wed, 29 Apr 2015 08:37:28 GMT

Yes.