If else statement and filter csv files

Hi again, i just wanted to clarify if it's possible to make an if statement like this

if(selected${node},'yes') then
csv-files-collumn = 1
csv-files-collumn = 2
csv-files-collumn = 3
csv-files-collumn = 4

btw if is possible, where i should put this, eg, appearance, relevance, calculation, filter??

i hope u get my questions.

thank you very much.

1 Like

What is use of these kind of files???

hello indian_stalker

i just wanted to filter the selected column(machine_key)

here's my pre-loading data.

thank you

machinedetails.csv (17.3 KB)

It sounds like you are trying to use some key to display a variable amount of data. What I'd do here is use hhmach_key to pull the data from the various columns into a few calculates. For example on for machine, one for brand, etc.

Once you have that data out of the CSV and into the form, you can use use the normal form syntax to display as much or as little as you'd like. One easy way to do that is to use the note data type and in your label put something like this.

key: ${key}
brand: ${brand}
model: ${model}

And if you want to have customized views, make different notes with different labels and use relevancy to show the appropriate ones at the appropriate times.

P.S. The if syntax is very precise: if(condition, a, b). If condition is true, then a, else b.

1 Like