Hi, I am trying to work find a script purpose of which is to count no. of Doors, Windows (List 2) against each item from List 1. Pictures being attached, please help.
I want the data i.e., Design Modification- Door Count 1, Window count 1,
Design Clarification- Door Count 1, Window count 1.
In the same way, for all 4 list items.
Project file.xlsx (12.5 KB)
Results visualize.dyn (162.0 KB)
Hello and welcome…could your share your files…its almost impossible to know whats goin on here…
Thank you so much for your response. I have edited my post and included all the files in it.
Hi @aneeqa_sikander and welcome, I do not know if this is what you are looking for, but it’s worth the shot, take a look at it:
I think you need to separate the categories (indices 1 and 5) first and then combine those with the the first list.
a = List.RestOfItems(List.Clean(lst,false));
b = List.GetItemAtIndex(a<1>,6..5);
c = String.Split(List.FirstItem(b<1>),",");
d = String.AllIndicesOf(List.LastItem(b<1>)<1>,["Windows","Doors"],false);
e = ["Window Count : ","Door Count : "] + List.Count(d<1><2>)<1>;
f = List.Flatten(List.AddItemToFront(c<1><2>,e<1>),1);
The same with nodes …
Results visualize-1.dyn (34.5 KB)
