Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. 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