Assing value to an empty field in load script

[#1]

Hi there,

hopefully someone can help me.

My data is looking basically like in table below. There is an order number, a couple of machines for each order number (I was not very creative in thinking of good machine name ) and of of the machines is considered to be the leading machine of the production line.

Order_Nr	Machine	Leading	Customer_Requests
324654/TL01	Purple	X	2
324654/TL01	Blue		4
324654/TL01	Orange		3
394562/TL01	Black	X	5
394562/TL01	Grey		1
394562/TL01	Yellow		0
315649/TL01	Brown	X	2
315649/TL01	Green		5
315649/TL01	Red		1

What I need to display in my application is a table that shows following information (filled with examples):

Order_Nr	Leading Machine	Total Customer_Request	FA_Date	Sales_Rep
324654/TL01	Purple	9	15.04.2012	John Doe
394562/TL01	Black	6	01.02.2013	Jack Frost

Basically I just want to count the amount of Customer_Request for each order and show the leading machine. But how can I achieve the latter? If I just display the row containing the leading machine I only the that specific amount of customer requests. Do I need to create a new column in my load script containing the leading machine for each order_nr? If so, how can I do that?

What might be important is that my data is sorted in my .qvd-file with a so called "equipment number" and not by the Order_nr. Thus the order numbers are not sorted as shown in the first table but are scattered all around the qvd.

Thanks a lot and best regards,

Max

[Gysbert_Wassenaar · Accepted solution]

It's not necessary to create a field in the script. You can use a chart expression to get the leading machine: only({<Leading={'X'}>}Machine)

[#3]

Hi,

it is really that easy - I should get used to set analysis.

Thank you!