I have a field called travelinterest and data extension name called testforelavaran, i dont know how many values in that field, suppose if that field contains four values,(col1,col2,col3,col4) and i want to count the values using rowcount, by using for loop and i will concetenate all the four values by using semicolon

> I have tried:

    %%[ 
    var @travelinterest, @rows, @rowCount,@interestsTemp
    set @rows = LookupRows("testforelavaran","travelinterest", @lookupValue)
    set @rowCount = rowcount(@rows)
    for @i = 1 to @rowCount
    set @interestsTemp = concat(
        iif(empty(@travelinterest[i]),'',concat(@travelinterest[i],';'))
    ]%%
but it is not working, please help me with amp script code,

> My output will be - output value is %%(travelinterest)%%
> (col1;col2;col3;col4)