How to fetch value from array?
Hello Team,
I have the below array and I need to fetch the filename where active=1. Please can you help me on this.
“array” : [
{
“active”: 0,
“fileName”: “test.pdf”
},
{
“active”: 1,...
Forum Discussion
Abhishek_117 - I think the answer you're looking for is already an option in the CSV Parser snap. In the "Header size error policy", select "Trim record to fit header". This will ignore any extra columns in the input data.
Hope this helps!
Hi @Manigandan,
@marjan.karafiloski’s solution will help you in this case.
If you want to keep everything in one mapper, then take a look at the array filter function:The expression would look something like this:
$array.filter(x=>x.active == 1)Regards,
Bojan
