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: 
Not applicable

How to Concise Duplicate Value

Hi,

I got a table with same TicketNumber value but inside contain different value for each TicketNumber such as Station and Amount as following :

TicketNumber     Station     Amount    

1                         E1               0

1                         K4               3

1                         A2               3

2                         E2               0

....

How can i going to concise TicketNumber into single record? as following

Ticket Number     EnterStation     ExitStation     Amount

1                              E1                    A2               3

1 Reply
sridhar240784
Creator III
Creator III

Jeffrey,

You can do this using FirsValue() and LastValue() Function in QlikVeiw.

Your Script should be some thing like below one.

Test:

Load * inline [

TicketNumber, Station, Amount   

1, E1, 0

1, K4, 3

1, A2, 3

2, E2, 0

2, K5, 6

2, A2, 6

];

Inner Join

Load TicketNumber,

FirstValue(Station) as EntryStation,

LastValue(Station) as Station,

LastValue(Station) as ExitStation

Resident Test Group By TicketNumber;

Have a look at the attached application.

Hope this helps you.

-Sridhar