Reference Item not giving each value

  • 28 January 2021
  • 1 reply
  • 12 views

Hi,

 

I am having some issue with creating reference for a loop step. I have a list method and output for the list method is given below. Now I have a step to create the reference using the same list method and I am using reference item to take each value from the list output. Unfortunately list item is giving a concatenated value as the value of each item. 

 

List Output 

29669 31/01/2021
71804 31/01/2021
84656 31/01/2021

 

Value coming as reference item 296697180484656

What is the mistake I am doing while creating the reference? 

 

Regards,

Madhu

 


1 reply

Hi,

 

The issue is K2 is not able to find any primary column to differentiate between the data. So my suggestions are

 

  1. If possible use the table SMO and provide your condition in the filter section.
  2. In stored procedure, create a table variable with an ID column and make that as a primary column.

 

Regards,

Divya Raj

Reply