How to parse values generated from csv generator
Hi
I am generating csv from csv generator snap and i want to parse this csv i.e but csv parser snap cant be connected to the output of csv generator. How can i do this
Forum Discussion
Thanks @cjhoward18
I did initially look at this kind of solution however not all secretary are given a position of secretary some may be assistant or receptionist. the other problem is that not all secretaries report to architects.
If i was to write a script i would iterate through the document filtering firstly on architects and add them to a seperate list then if they have a secretery ID I would append those secretaries to that list.
Im wondering if this can be done without the script snap though as I would prefer to use the out the box components to make the support aspect of this easier however it may be a case that script is the simplest way to go
Hi Ksalem,
Good day, in the scenario where you want to consolidate or group by Position I usually do is a combination of array and object methods… here it goes…
First I tagged all the documents to have a groupId (pipe.ruuid) then group by fields groupId
Then create the objects (Positions) that will hold the array of information then filter main array and keep the item where Position is equal to the key
Then did some cleanup removing the groupId then lastly filtering the array of each position if SecID is empty remove it (I think here you can place your custom rules of filtering)
