Showing results for 
Search instead for 
Did you mean: 

In-memory lookup or Join functionality not working as expected.

New Contributor II

I have a data present in CSV file and I have user input parameter.
I want to get the complete record that matching with one of the column value in CSV to the input parameter.

Like in below screenshot, my input parameter is Role3 and it is matching with row4 in csv. So, i want to fetch all the data from Row4.


Issue: I tried to fetch the data using in-memory lookup snap. But, i got only 'Role3' as output instead of that whole record data(row4).
and I tried Join snap with Inner function, But not getting any output and with Outer function i got all the records from that CSV.

Please suggest / help me to get that complete Row data matching to input parameter.

Thank You.