How to Sort an Array Based on Key/Column name
Hi ,
I have an array which i want to sort it by the keys/column.
{
array1:[
{
" Width":“4”
" Length":“5 "
" Item Desc”:"Black ",
" Item ":"Pen "
},
{
"Width":"5"
" Length":...
Forum Discussion
Yes, though I would consider it “XHTML” (an old term)
Thanks @robin, I haven’t had a chance to test the solution you provided but I’m sure it would have worked.
I went with a different route for my development so the concern I was having has been resolved.
XML Generator does intake dynamic values if they have been binded properly prior to it (using Aggregate or Group By), the only challenge I found was ingesting native html tags because <a href ="$URL"> wasn’t generating the desired output as the tags gets converted to snapLogic’s predefined symbols like < = <,so on and so forth. Check these links for detailed explanation on tags conversion:
What I found and worked for me was defining the html format (if you’re trying to generate html files; could be any format you’re interested into) in the mapper itself/file writer and then let the format do its job.
Thanking @robin for his suggestions, time and help on this. Signing off from this thread.
Hi @Manigandan ,
You can use the Filter snap to filter out only active objects.
Please take a look at the attached pipeline.
00_Fetch_Active_2023_07_16.slp (4.6 KB)
Best regards,
MarjanHi @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
