Forum Discussion
Thanks Bojan for your quick reply.
Actually as per my requirement inside ‘group’ if getting a empty list ‘{}’, it should return false . But group.lengh is returning true even if list is empty(ie {}).
eg:
if JSON is like below it should return false.
“group”: [
{}
]
@Gayathry, go with the following expression:
$group.filter(x=>x.hasPath('ID')).length > 0
@Harsha3 - Try below approach-
Use group by N make it as 0 so all record should be grp by in one array, then change the table data path with your group name like below-Hi Supratim,
Thanks for the reply I have tried that approach still we get two rows instead of one for having two values.
Thanks,
Harshavardhana
Hi Alchemiz,
I was able to obtain the result as per your method . Thanks since I am new to IT with intermediate knowledge in snaplogic , I would like to know how to create a vertical table . Can you please help me in modifying the code which I published below ( This code creates horizontal table).
Email Snap HTML Table table.Snap {background-color:transparent;border-collapse:collapse;width:100%;} table.Snap th, table.Snap td {text-align:center;border:1px solid black;padding:5px;} table.Snap th {background-color:Aquamarine;}Hi Team,
Kindly find the attached sheet which contains affiliation and address mismatches in SIQ.
Success and Error record count:
Regards,
Related Content
- 11 months ago
- 2 years ago