LOAD INLINE is not working as intended

[vvira1316]

I'm creating table using following

String_Positions:
LOAD * INLINE [
    Change Number, StringNum, StringDesc
];

I've to assign values to field using following assignments

LET CHG_NUM = Peek('Change Number', $(i), 'AllCRs');

For one Change Number there can be multiple Apporval History information that I'm splitting from a field of previously loaded table and assigning it to following variables.

LET StringLen = $(EndPos) - $(BegPos) + 1;
LET StringDesc = Chr(39) & trim(Peek('Approval history', $(i), 'AllCRs')) & Chr(39);
LET StringDesc = Chr(39) & Mid(trim($(StringDesc)), $(BegPos), $(StringLen)) & Chr(39);

I've to insert above information into a table that I can use later for visualization.

Concatenate(String_Positions)
LOAD Distinct [Change Number], StringNum, StringDesc INLINE [ Change Number, StringNum, StringDesc
$(CHG_NUM) as Change Number,$(StringNum) as StringNum, $(StringDesc) as StringDesc];

I'm looping through for all records of AllCRs.

Issue I'm running into is that I'm getting improper assignment or NULL values into String Positions table. Please advise what is wrong here.

Thanks,

Vijay

[Nicole-Smith]

It's hard to tell only seeing bits and pieces of your script.  Can you post your load script and a sample app?  Or at least your log file?

[vvira1316]

Hi All,

Thanks for prompt help. I figured what the issue was. It was misspelled field name. Now it is working.

Cheers,

Vijay