Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Try
Crosstable (Country, Price, 1)
Load * From ... ;
ID | HK | SE |
1 | 20 | 10 |
2 | 30 | 35 |
3 | 40 | 60 |
4 | 50 | 75 |
No, I think you should use Crosstable.
Crosstable (Country, Price, 1) Load ID, HK, SE From ... ;
An alternative approach is
For each vCountry in 'HK', 'SE'
Load ID, '$(vCountry)' as Country, [$(vCountry)] as Price From ... ;
Next vCountry
/HIC