Discussion Board for collaboration on QlikView Scripting.
I have the following problem.
I have two tables:
WH_START:LOAD RecNo() as Recno,WM.ID as ID,WM.DATE as DATE,WM.MUTATION as MUTATION,RESIDENT WMWHERE WM.MUTATION = 'WA'OR WM.MUTATION = 'NA'OR WM.MUTATION = 'WI';
WH_END:LOAD RecNo() as Recno,WM.ID as ID,WM.DATE as DATE,WM.MUTATION as MUTATION,RESIDENT WMWHERE NOT WM.MUTATION = 'WA'AND NOT WM.MUTATION = 'NA'AND NOT WM.MUTATION = 'WI';
Like you see both tables are from the same "mother" table.
The together they are the mother table
Now is the problem that I want to make a new table from all the rows from the first table and add the rows from the second one.where (WH_START.Recno + 1) = WH_END.Recnoand WH_START.ID = WH_END.ID
Here i have a example
I hope somebody can help me.
Go to Solution.
Join the two table using join key word.
recno() as StartRecono,
from table 1
recono() as endRecno,
id from Table2
Keep the ID field name as same and change rest of the fields from the both the tables to a different names.
I hope this helps
Tnx I think that will work for me