Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Run IF Condition

Hi! Guys, what I wanna do Is sending a file with ftp only if one row from a table is less than 0.
I have the ftp connection with the connectpor "FTPPU" but I don't know how to do the condition. I mean, I have to start this ftput when the value from one row is "the condition". I tried to use the "run if" but when I put the condition "nameoftherow > 0" says that "nameoftherow" is not a variable.
I don't know If I have explained my problem very well, I hope you guys can help me because using "tmap" I know how to make condition, but I don't know how to make it using "run if" using row from my DB.
Labels (2)
13 Replies
Anonymous
Not applicable
Author

Hi,
Can you please share screenshot of if condition..??
So I can find problem.
In if condition, write following statement to compare string
((String)globalMap.get("maqiuna")).equals("1998")
Best Regards,
Amol  0683p000009MACn.png
Anonymous
Not applicable
Author

The if condition is pretty much the same as the trigger OnComponentOK but combined with a condition.
I guess the if condition is supposed to work per record. I suggest a different design:
tDBInput --row1--> tFilterRow ----> tFlowToIterate --Iterate--> tFTPPut
I guess the tJavaRow was simply a kind of anchor? If there was some logic, add it before the filter in the flow.
Anonymous
Not applicable
Author

Hi,
Can you please share screenshot of if condition..??
So I can find problem.
In if condition, write following statement to compare string
((String)globalMap.get("maqiuna")).equals("1998")
Best Regards,
Amol 0683p000009MACn.png

Just like this. 0683p000009MDeU.png
Anonymous
Not applicable
Author

The if condition is pretty much the same as the trigger OnComponentOK but combined with a condition.
I guess the if condition is supposed to work per record. I suggest a different design:
tDBInput --row1--> tFilterRow ----> tFlowToIterate --Iterate--> tFTPPut
I guess the tJavaRow was simply a kind of anchor? If there was some logic, add it before the filter in the flow.

This worked! Thank you : )