topic Load script question in QlikView

Load script question

jduluc12 — Wed, 21 Feb 2018 13:18:35 GMT

I have a data set like this

Item	Customer
Item1	Cust1
Item1	Cust2
Item1	Cust3
Item2	Cust3
Item2	Cust3
Item3	Cust1
Item3	Cust1

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

Item	Level
Item2	Cust3
Item3	Cust1

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

Re: Load script question

tomasz_tru — Wed, 21 Feb 2018 13:26:53 GMT

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

Tomasz

Re: Load script question

jduluc12 — Wed, 21 Feb 2018 13:27:53 GMT

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?

Re: Load script question

jhoef-pv — Wed, 21 Feb 2018 15:09:43 GMT

HI JEAN,