Join tables with a inputfield

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

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;

[#3]

Thank you for the precise answer.

[#4]

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

[Gysbert_Wassenaar]

Yes.