Concatenate in GAMS
Posted: Fri Jun 11, 2021 10:39 am
Hi,
I am importing two different tables into GAMS:
RotStandOut(SiteIndexS,SiteIndexP,SiteINdexB,Rot_Perc,Ages,Items)
PixTable(Stands,Pixels,SiteIndexS,SiteIndexP,SiteIndexB,Rot_Perc,Items)
Both tables have common sets (SiteIndexS,SiteIndexP,SiteINdexB,Rot_Perc). I need to group those sets together creating sort of an "Index/key", so I can identity such index on table RotStandOut and bring its outcome/value to table PixTable.
What I want to do is kinda of concatenating such sets in both tables and then performing a vlookup.
Any ideas on how I can do that on GAMS?
I am importing two different tables into GAMS:
RotStandOut(SiteIndexS,SiteIndexP,SiteINdexB,Rot_Perc,Ages,Items)
PixTable(Stands,Pixels,SiteIndexS,SiteIndexP,SiteIndexB,Rot_Perc,Items)
Both tables have common sets (SiteIndexS,SiteIndexP,SiteINdexB,Rot_Perc). I need to group those sets together creating sort of an "Index/key", so I can identity such index on table RotStandOut and bring its outcome/value to table PixTable.
What I want to do is kinda of concatenating such sets in both tables and then performing a vlookup.
Any ideas on how I can do that on GAMS?