Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
HI JEAN,
what's the data source? It would be better to do it in SQL.
Tomasz
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?
HI JEAN,