Expression Help

[danielnevitt]

Hi,

I would appreciate some help with the below expression.

I have the following data:

Vessel Name          Act           Port

Dan123                   L              UK

Dan123                   D              France

I would like to create a table that show the data as:

Vessel Name          Load Port             Discharge Port

Dan123                   UK                       France

I thought I could use If(Act='L',Port), but it didn't work.

Thanks,

Daniel

[Anil_Babu_Samineni]

That means, Each field name should store it as Act? Is that you are expecting? Can you explain the use case for your customers?

[rubenmarin · Accepted solution]

Hi Daniel, have you tried?:

Only({<Act={'L'}>} Port)

or "Concat(distinct {<Act={'L'}>} Port, ', ')" if Vessel Name can have more than one port for Act='L'