Hi Team,
i have 2 materials in which i have pass the cost, so from input i am splitting the data based on the separator(“100|200”) but sometimes for few materials they dont provide cost so we to mention as zero (“1000”) in this example if they mention 1000 i have pass 1000 in one material and 0 in other material. but my issue here is in the input excel if they provide separator then array contains only 1 value that is 1000 in the next material it is failing as Index was outside the bounds of the array. what should i do so that array will have zero for all other materials if they havent mentioned any data?
You can use if activity after spliting the values.
Like condition arr.count>1 then you can proceed with your steps
else
assign
arr.append(0).toarray
it will not work nikhil, actually in the next entry in excel they just mentioned as 1000 didnt give any separator, if they have mentioned 1000| like this then append might work
Hi shiva,
Thank you for the suggestion, it worked for my but with little change instead of array i changed the datatype to list.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.