This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
As the title suggests, I want to copy the data from one row 4 times if the value in one column is API, and 2 times if the value is MX Loader. I've tried using the Generate Rows Tool, but keep running into errors such as: "Invalid type in operator==." and "The value did not change after the Loop Expression"
I'm fairly new with this tool and tried adding a condition expression of "
if contains([MX Loader/API],"API") then + 4 elseif Contains([MX Loader/API], "MX Loader") then + 2 else Null() endif "
If anyone has any solutions, it would be greatly appreciated.
I have a similar query to this. Just that in my case i need a specific value to repeat itself multiple times, till a change of condition in the underlying column. For e.g.see below:
For every change in Level to equal 2 (i.e Level =2) I need the corresponding "DESC" of that Level 2 occurrence to repeat for all subsequent records in a separate column, till the next available instance of Level 2 with a different DESC. The occurrence of "Level =2" will be dynamic, i.e. can occur after any n number of records.