Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
andreyfcdk91
New Contributor III

Re-writing data from other source

Good day!

In my test model i want to update data (Source1)  from data (Source2)

If there're some existing YearWeeks from Source2, system must update NomId and Sales for it and add new data (not existing YearWeeks)

My necessary result table:

 

YearWeekNomIdSales
2015014534
2015012234
2015026344
20150323234
20150487424
20150511435
2015062266
1 Solution

Accepted Solutions
MVP
MVP

Re: Re-writing data from other source

This Load Script should do the trick for you:

2016-01-20 #1.PNG

2 Replies
MVP
MVP

Re: Re-writing data from other source

This Load Script should do the trick for you:

2016-01-20 #1.PNG

andreyfcdk91
New Contributor III

Re: Re-writing data from other source

Thanks so much

Community Browser