Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
Thank you for the precise answer.
Is it a real problem if joining tables creates a circular join?
Yes.