This content has been marked as final. Show 2 replies
I make it.
set i=0; set BUKRS=''; Rows: LOAD BUKRS FROM [~\BsisSocEjer.QVD] (qvd) ; let rows=NoOfRows('Rows'); Trace $(rows); for i=1 to '$(rows)' Trace $(i); let BUKRS=FieldValue('BUKRS',$(i)); Trace $(BUKRS); BSIS_Complete: SQL SELECT * FROM BSIS WHERE BUKRS = '$(BUKRS)' ; next Store BSIS_Complete into [~\BSIS_Completa.QVD](qvd); Drop Table BSIS_Complete;
The key was bringing first fieldnames correctly.
After naming the field I was bringring in the first LOAD statement, FieldValue has been able to get the value correctly.
Thanks for reading, hope that this answer will help.