Array variable has incorrect number of subscripts or subscript dimension range exceeded

[VinMe]

I am unable compare two 1d arrays  and to assign values to third array $aDSloc1, Please help me out

Local $aDSloc1[$LastRow]
For $i = 1 To $LastRow
    For $j = 1 To $LastRow1
        If $aDSlist1[$i]== $aLocDS1[$j] Then
            $aDSloc1[$i] = $aDSloc1[$i]+"," + $aLocNr1[$j]
        EndIf
    Next
Next

Edited August 28, 2019 by VinMe

[mLipok]

FOR $J=0 To $lastrow-1

???

[VinMe]

ceratainly yes mLipok!! that was my stupid mistake. updated code looks like this.

Local $aDSloc1[1] = [""]
For $i = 1 To $LastRow
    For $j = 1 To $LastRow1-1
        If $aDSlist1[$i] == $aLocDS1[$j] Then
            $aDSloc1[$i] = $aDSloc1[$i] + "," + $aLocNr1[$j]
        EndIf

    Next
    ReDim $aDSloc1[$LastRow]

    _Excel_RangeWrite($oWorkbook, $oWorkbook.ActiveSheet, $aDSloc1[$i], "H" & ($i))
Next

But one more question here, is the below code line is good? i am not getting the right result so..

$aDSloc1[$i] = $aDSloc1[$i] + "," + $aLocNr1[$j]

[Subz]

Use ampersand "&" to concatenate.

[Bilgus]

'&' is the string concatenation character not '+'

 

$aDSloc1[$i] = $aDSloc1[$i] & "," & $aLocNr1[$j]

 

[VinMe]

thank you guys, i am really new to autoit...