with the Column Expression Node I’m computing Hex-Strings to Decimals and in the following Column Expression Node I use the Two’s complement to compute negative values. Because I have to do this for 35 Columns, I try to parse the Hex-Columns in a Column List Loop. The first iteration is running fine but in the second iteration the Two’s complement Column Expression Node crashes because there are two columns insted of one becaus the first Column Expression Node “forgets” the checkbox ‘Replace Column’. This forgetfulness only happens in the second iteration…
Has anyone an idea how to fix this problem?
Just thinking out loud here - I think you need to have a flow variable to govern the output column according to the current iteration of your loop - otherwise it’s just going to try to replace the same column every time, right? Maybe that’s why the checkbox is acting strange?
Because of the Column List Loop Node I have the actual column name. The Cell Splitter Node appends the name “_SplitResultList” so I append this name to the acutal column name with the String Manipilation Variable Node.
In the first iteration this configuration work fine. In the second iteration the Column Expression Node “forgets” the checkbox to replace the input column.
find attached the snipped of my workflow with some example data in the Table Creator Node. I hope four coulmns with data is enough. I tryed it in the example workflow and the checkbox ist missing after the first iteration.
