Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Creating a Unique ID from Multiple Rows of Data

Hi,

I have data a little like this:

FieldValue
IP812
SiteNorth
ServiceAcme
IP813
SiteSouth
ServiceAcme
IP814
SiteNorth
ServiceBang

 

I know that the data that belongs together is on 3 rows, e.g. 1,2 and 3 is one record, 4,5,6 is another and so on.

What I need is:

IPSiteServiceUnique ID (created)
812NorthAcme1
813SouthAcme2
814NorthBang3

 

Any advice appreciated, as I have no control over the data format I'm receiving.

Cheers,

Dean

Labels (2)
11 Replies
Highlighted
Specialist
Specialist

Thanks Saran

Highlighted
Creator
Creator

Perfect, Thanks for your help