Hi everyone, I’m not very pro at make but i would like to make things works for learning problem solving.
I would like to use output from a google sheets search rows module, to add it to a google sheets depending on if is already in the file or not.
So, if the searched term is already in a column (B), I would like to write it (the output) in an other column (C). If it isn’t in the colum (B), i would like to add the term (input) in the same column (B).
Here is comes the problem:
The search rows (standard) module returns only numeric output (true/1) and (false/0) under “Total numbers of bundles”. I need the actual term (text) I used in the input.
So I did it, with search rows (advanced). The module returns the term I used like input but only (obv) if it matches condition of existences in the defined row.
So data with total numbers of bundles = 1, it shows in text (showing the term matched) and the data not matched, with total numbers of bundles = 0, it shows only “0” in output and not the input data in a text value.
With these results, I can use the matched data, but not add the not matched data in the sheets because is not returning the text value.
How can i get the text value for not matched data? Is there a query google expression?
I already used an interator module, for trying to extract the value of input but with no changes.
I tried adding, “if is and is not” in the query function with no clue.
Providing useful things:
module-1-output bundle op2.txt (46 Bytes)
module-1-input bundle op2.txt (216 Bytes)
module-1-output bundle.txt (122 Bytes)
module-1-input bundle.txt (221 Bytes)
blueprint.json (99.7 KB)
Thanks in advance