Merge 2 columns and create new column

[KirstenKa]

See also attachment. My data looks like this

Season	Year
SS	2024
SS	2024

And I would like to merge the 2 columns and add a column like this. I would like to do this by adding a code in the load script. How to do this?

SeasonYr

SS2024

SS2024

[sidhiq91]

@KirstenKa  Please follow the below script to get the desired ouput.

NoConcatenate
Temp:
Load
Season&Year as SeasonYr
Inline [
Season, Year
SS,2024
SS,2024

];

Exit Script;

If this resolves the issue, please like and accept it as a solution.

[KirstenKa]

See also attachment. I think it almost works, I implemented the script like this:

It gives an error in the yellow marked because when I remove yellow marked, the script at the bottom is correct again.

Should exit script be above IF?