Skip to main content

In my Workflow Model, the daily soil temperature is decided by itself and other parameters one day before.

For example, I created column A (the present soil temperature Ts1), column B(air temperature Ta1), and column C(the soil temperature next day Ts2) in Excel and I had the soil temperature from day 1 and daily measure data of air temperature for 3 days.

 

????73

 

 

I have created a looper in FME, i wanna input Cell A2, B2 to calculate and output the value in C2 at the first looping.

At the second looping the value in C2 would automatically return as input value A3. With the measure value B3, the value C3 would be calculated, until we have all the soil temperature for 3 days.

How can i use the reader, writer, and looper in FME to achieve this?

You're trying to get it do something like below? In this example I added A+B=C, carried C to the next row, and looped it over and over. It should be pretty easy to work through.

 

Attached fmwt file.

 

Spreadsheet

 sheet

 

Workbench

 Loop

Let me know if this is close.


You're trying to get it do something like below? In this example I added A+B=C, carried C to the next row, and looped it over and over. It should be pretty easy to work through.

 

Attached fmwt file.

 

Spreadsheet

 sheet

 

Workbench

 Loop

Let me know if this is close.

Thank you for your answer. I really appreciated it. But i have tried this method already and now i have one more question. In this picture, i want to add A+B+C=E, B+D=F, and return value E to A, and value B to F. How can i achieve that?屏幕截图(75)


There's no need to use a looper here, you should be able to do what you want with adjacent attribute handling in the AttributeCreator

Capture

 

If the TS1 value of the previous feature has a value, i.e. it is not the first feature, set the Ts1 value to equal the TS2 value of the previous feature. Use whatever calculation you need to then create the TS2 value on that feature


Reply