Collumn name to ID rows

[Gump123]

Need help. I do have script 

Load

("PAX ") as "B Passengers ",
("Pax Breackdown") as " Passengers Tran",
("Transfer Revenue ") as "Transfer Revenue",

Now i want to create one additional collumn name ID  which has following value if 

PAX   assign ID  1 

Pax Breackdown  assign ID 2

Transfer Revenue assign ID 3

Basically Assign ID no 

[G3S]

are you able to provide a mockup of expected result?

[Gump123]

ColumnID should have  1 2 or 3 value. Based on the following column 

("PAX ") as "B Passengers ",
("Pax Breackdown") as " Passengers Tran",
("Transfer Revenue ") as "Transfer Revenue",

[G3S]

hope I've understood your requirement correctly. add the below to your load:
1 as B Passengers_ID,

2 as "PassengersTran_ID",

3 as "TransferRevenur_ID"

this will add three new fields with fixed values 1, 2 and 3. 

to have it in one field, use 'crosstable' function so it looks like this:

[sidhiq91]

@Gump123  Please see the Script below:

NoConcatenate
Temp:
Load RowNo() as Row_Number,
PAX as "B Passengers ",
Pax_Breackdown as "Passengers Tran",
Transfer_Revenue as "Transfer Revenue"

Inline [
PAX ,Pax_Breackdown ,Transfer_Revenue
1,2,3
]
;
Temp1:
Crosstable(Column,ID,1)
Load * Resident Temp;

Drop table Temp;
Drop Field Row_Number from Temp1;
Exit Script;

Let me know if this has resolved your issue,if yes please like and accept it as a solution.