Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jduluc12
Creator
Creator

Load script question

Hi

I have a data set like this

ItemCustomer
Item1Cust1
Item1Cust2
Item1Cust3
Item2Cust3
Item2Cust3
Item3Cust1
Item3Cust1

I need to write a load script where the table looks like this

ItemLevel
Item2Cust3
Item3Cust1

So What is happening here is,

The Item2 and Item3 have only one customer getting repeated over time. The Item2 has Cust3 and Item3 has Cust1.

So the final table in the data model will contain only those Items which have same customers repeated over times and discard the items which has different customers repeated over times like Item1 which has different customers associated with it.

any ideas?

Thanks

1 Solution

Accepted Solutions
jhoef-pv
Contributor III
Contributor III

3 Replies
tomasz_tru
Specialist
Specialist

what's the data source? It would be better to do it in SQL.

Tomasz

jduluc12
Creator
Creator
Author

In fact it is qvd file and i do not have access to the database to write sql on it.

Do you think it is not possible to do this operation in load script?

jhoef-pv
Contributor III
Contributor III

HI JEAN,

Captura.PNG

Captura.PNG