Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created two resident tables: T1_Active3 and T2_Term3. I want to append the records from T1 and T2 into a new table called T5_Retention Detail. I tried the following script, but it did not work. I've attached the qvw file and edata.
I read your response again. You explained that the NoConcatenate removes the autoconcatenate.
You are first creating a new table T5_Rentention_Detail
Without the NoConcatenate it will auto concatenate onto T1_Active3
Then because the following Concatenate is not qualified to a particular table it will also auto concatenate onto T1_Active3
Then when you drop T1_Active3 you no longer have the table as you've just dropped it.
Perfect, thanks again, I understand now. I am very new to Qlikview, just taught myself in a few days, so I'm still learning.
I understand now, thanks so much.