# Variables in Knime

**URL:** <https://forum.knime.com/t/variables-in-knime/80968>\
**Category:** KNIME Analytics Platform\
**Tags:** excel, flow-variables, bug, big-data\
**Created:** [July 8, 2024, 6:44pm UTC](https://forum.knime.com/t/variables-in-knime/80968 "2024-07-08T18:44:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![liazi](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/l/8797f3/32.png) [@liazi](https://forum.knime.com/u/liazi)\
**Post date:** [July 8, 2024, 6:44pm UTC](https://forum.knime.com/t/variables-in-knime/80968/1 "2024-07-08T18:44:04Z")

</div>

There is this table of information here and I need all of it to be a variable in Knime, so that the values, if they are changed in excel, are automatically changed in Knime

This “De” and “Até” are the bases for taking the values, if they are between these two, take the value that is in column 2 and 3

In other words, if the value is less than or equal to 0, take the first column, if it is greater than or equal to 2112.01 and less than 2826.65, take the second row and so on.  
 ![Imagem do WhatsApp de 2024-07-08 à(s) 15.38.29_098f882a](https://forum-cdn.knime.com/uploads/default/original/3X/c/f/cf996798a088192fdc9927db870cd090191d1317.jpeg)

---

<div class="post-metadata">

**Author:** ![ArjenEX](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/a/97f17d/32.png) [@ArjenEX](https://forum.knime.com/u/ArjenEX)\
**Post date:** [July 10, 2024, 11:03pm UTC](https://forum.knime.com/t/variables-in-knime/80968/2 "2024-07-10T23:03:16Z")

</div>

Hi @liazi

Your explanation is hard to follow. What’s “the value”? You are looking the compare column3 with the n+1 values of DE and Ate and then populate column1?

Please provide your input in a workable format and draft the expected output with a logical explanation on how to get there.

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [October 8, 2024, 11:03pm UTC](https://forum.knime.com/t/variables-in-knime/80968/3 "2024-10-08T23:03:59Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
