Discussion Board for collaboration related to QlikView App Development.
I have a requirement that
1. Hardcoded records (5) should be concatenated to the below tables. it has a ID column which start with 1 - 5 as the rows, along with Desc column.
2. Second, i load the table from DB, which has ID and Desc, ID is autonumber of Desc column,
3. it will autoconcatenate, and results will be like ID has duplicate values from Hardcoded inline and Db. But i dont want this result.
4. I require the result like, ID first 5 rows from Hardcoded inline and next onwards from another table, which should be sequential, ID column - Values should be unique.
Please help me to complete this requirement.
Thanks in Advance
Go to Solution.
May be like this,
LOAD * INLINE [ //Table 1
LOAD max(ID) as MaxID Resident T1;
LET vmaxNo= Num(Peek('MaxID', 0, 'MaxNo'));
DROP Tables MaxNo;
LOAD ID + $(vmaxNo) as ID,Desc; //Table 2
LOAD * INLINE [
You can use RowNo() to sequentially number the rows.
LOAD * Inline
LOAD RowNo() as ID,
RowNo() will automatically start at 6 for the DB rows.