Transform Data to facilitate comparisons

[jjj]

Hi community, 

I faced this issue and can't figure out. 

My data are simple (left table) and I'd like to build the right table in a straigthtable-chart  (no pivot). Of course I dont' want to do this in the script.

The result is one row by Id with the city of Type=1, city of Type 2 and the associate value

I try to use P() without success.

Thanks for your help

Cheers !

JJJ

[ogster1974]

for a straight table try Only({<Type={1}>} City) as City1 etc...

[jjj]

Thanks it works well !

[ogster1974 · Accepted solution]

glad it solved your problem.

please mark solutions as correct or like to help others with similar issues in the future find this post and its answer.