I want to test 2 conditions with the tFilterRow component, but it don't work.
This is my job :
directory : "D:/SPC/FichienSensibilite"
files : "*.dat"
flow's name :
Freq Vide Vaut "Fréquence=1000Hz"
Freq Vide Vaut "Temps=50µs"
Run IF :
((Integer)globalMap.get("tFilterRow_1_NB_LINE_OK")) > 0
file's name :
directory : "D:/SPC/test"
For my tFileInputDelimited_1 component, I use a metadata delimited file wich is form :
Colonne0 is a String type.
Do you have an idea to test two results on the same column ? Can you help me, please ?
PS : My job is in French
Solved! Go to Solution.
What is the issue ? did you check if you put 'AND' or 'OR' option in your filter row.
Because in the case of 'AND' you will not have any result.
So first in the value Field you should put only the value not "Frequence =1000".
and in the input column you should specify the column that you want to apply your filter.
Like input column = Frequence and value 1000 ( in case of int variable else you put "1000");
To copy a file, I want to check if their are on the colonne0 "Fréquence=1000Hz" and "Temps=50
µs" not OR.
If I choose OR I will copy Files with "Fréquence=1000Hz" and "Temps=60
µs" or files with "Fréquence=5000Hz" and "Temps=50
I look other messages
In this case you put in the column input "column0" in your both filters and add the conditions.
Please test it.
if you stil have error plus share the metadata of your file.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema