Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Re: How to create a new row without editing in excel

Hi Jagan,

Please find the below query

I am new to incremental load, kindly help with the underline query resolution

Please find the below tables 1 and 2 with details :

Table 1: 20 unique records and

Table 2: 10 records (i.e. 4 records Old order Old date, 3 New record orders and 3 Old order with New dates)

Table 1:

Product    ProdName    Price    Updated

101    Watch    150$    1/1/2015

102    Ring    300$    2/2/2015

103    Fruit    30$    3/3/2015

104    Jeans    50$    4/4/2015

105    Pen    12$    5/5/2015

106    Wallet    25$    6/6/2015

107    Shoes    70$    7/7/2015

108    Tshirts    100$    8/8/2015

109    Laptop    500$    9/9/2015

110    Keyboard    350$    10/10/2015

111    Furniture    400$    11/11/2015

112    Socks    20$    12/12/2015

113    Bags    85$    1/13/2015

114    Belts    50$    1/14/2015

115    Trousers    200$    1/15/2015

116    Saree    220$    1/16/2015

117    Books    100$    1/17/2015

118    Bracelet    120$    1/18/2015

119    Caps    30$    1/19/2015

120    Footwears    160$    1/20/2015

Table 2:

Product    ProdName    Price    Updated

101    Watch    150$    1/1/2015    Old

102    Ring    300$    2/2/2015    Old

103    Fruit    30$    3/3/2015    Old

104    Jeans    50$    4/4/2015    Old

105    Pen    12$    20/5/2015    Date  Updated

106    Wallet    25$    26/6/2015    Date Updated

107    Shoes    70$    27/7/2015    Date Updated

121    Flowers    35$    12/12/2015    New

122    Jewellery    425$    13/12/2015    New

123    Key Chains    17$    12/12/2015    New

Reading the 6 records, Using Where Not Exist will give 17 records (17 because, we need to delete the exisitng 3 old records from the 20 records)

At last, concatenating 6 records (i.e. 3 New record orders and 3 Old order with New dates) to the 17 records, resulting into 23 records

Kindly help me framing a script based on this, I'm stuck. Beacuse what Roman have suggested worked for Records (i.e. Composite key gave me unique records=23) and not for Products (i.e. Need to get record orders=23)

Thanks in advance

2 Replies
MVP
MVP

Re: How to create a new row without editing in excel

Replied to original thread check there.

sli
Valued Contributor II

Re: How to create a new row without editing in excel

Jagan- I have branched this question- perhaps you can take a look at this question separately? Thanks!

Sara

Community Browser