List of Contributions

Sarita Gerbig

Contact Details

My Content

1 to 20 of 21 total

RE: List of node type and node names in any given dataflow

Posted By Sarita Gerbig 12-13-2023 13:07
Found In Egroup: Data360 Analyze \ view thread
Thank you, Adrian. The .lod file will indeed be useful to me. ------------------------------ Sarita Gerbig Consultant, Internal Audit Windstream Communications ------------------------------

List of node type and node names in any given dataflow

Posted By Sarita Gerbig 12-12-2023 18:00
Found In Egroup: Data360 Analyze \ view thread
Just throwing this out there! Is there a way to get a complete list of all dataflow nodes including node type, current node name and the composite name in which they reside? ------------------------------ Sarita Gerbig Consultant, Internal Audit Windstream Communications ------------------------- ...

RE: Moving files from Share Point to data360 server and using the dir node

Posted By Sarita Gerbig 04-08-2022 08:33
Found In Egroup: Data360 Analyze \ view thread
Adrian - has there been any Infogix development w/regards to creating a node that would transfer a SharePoint 365 file to a data360 server? I know you alluded to that but wonder if any work or other interest has brought this issue to the forefront. Continuing to use the os command though...

RE: JSON node - how do i use it

Posted By Sarita Gerbig 01-20-2022 07:28
Found In Egroup: Data360 Analyze \ view thread
John - thank you! and thank you for a quick response. I'm running now!

JSON node - how do i use it

Posted By Sarita Gerbig 01-19-2022 13:55
Found In Egroup: Data360 Analyze \ view thread
I am trying to import the output from an api query that i dropped into a file but just can't understand how to set the node up correctly. the output can be found using this link: https://opendata.usac.org/resource/96rf-xd57.json/?funding_year=2019

RE: Moving files from Share Point to data360 server and using the dir node

Posted By Sarita Gerbig 06-09-2021 15:59
Found In Egroup: Data360 Analyze \ view thread
In light of major cyber attacks of recent - and those coming at lightning speed - taking giant steps to minimize exposure is a super high priority. Moving files via uploads/downloads to safer environments (like SharePoint) while still maintaining automation that was in-place prior to a move [like to ...

Moving files from Share Point to data360 server and using the dir node

Posted By Sarita Gerbig 06-07-2021 13:21
Found In Egroup: Data360 Analyze \ view thread
I have found that there isn't a node to upload files sitting in a sharePoint folder. Are there any plans to develop one in a future release? I was lucky enough to find someone who coded what I need to move the file from sharepoint to the server one specific file at a time - AND, if to automate, ...

RE: cvs unescaped quote

Posted By Sarita Gerbig 03-19-2021 12:32
Found In Egroup: Data360 Analyze \ view thread
Second option didn't work for me. Not sure what you are describing in option 1. Are you saying create a parameter named UnescapedQuoteHandling or ls.brain.node.csv.unescapedQuoteHandling? If the later - didn't work either.

cvs unescaped quote

Posted By Sarita Gerbig 03-18-2021 18:03
Found In Egroup: Data360 Analyze \ view thread
I am struggling to import a JDE F1201 table as a csv! I’m chasing errors like "Record: 942, Unescaped quote character '"' inside quoted value of CSV field. " I've tried every "ignore" available to me and tried other "things" to get the node to import. When I import the file into excel or text, I can't ...

Import flat file with no delimiter in data360

Posted By Sarita Gerbig 11-30-2020 10:41
Found In Egroup: Data360 Analyze \ view thread
In LAE I was able to import a flat file using the Delimited File Node by using the \n for field delimiter and \n as record delimiter - then declaring one field name = Data. I can't find another import data node that will do the same. When using the CSV/Delimited Input Node, it errors as "The delimiter ...

RE: Create field in Merge Node for left, match and right outputs

Posted By Sarita Gerbig 11-18-2020 12:39
Found In Egroup: Data360 Analyze \ view thread
Adrien - thank you so much. I tried many ways similar to this but forgot to address the new fields in the configure! Thanks for being here, Sarita.

Create field in Merge Node for left, match and right outputs

Posted By Sarita Gerbig 11-17-2020 15:42
Found In Egroup: Data360 Analyze \ view thread
In LAE X-ref, we could create a new field for left,match and right outputs. Could you please show me how to do that with the Merge node? I'm sure there's a way :) output 1 ( emit 1:*, "In left only" as Result where join.leftOrphan ) output 2 ( emit *, "it matches" as Result exclude ...

RE: What is d360 equivalency to LAE abort() function from Lavastorm

Posted By Sarita Gerbig 10-28-2020 10:51
Found In Egroup: Data360 Analyze \ view thread
thanks!

What is d360 equivalency to LAE abort() function from Lavastorm

Posted By Sarita Gerbig 10-15-2020 14:21
Found In Egroup: Data360 Analyze \ view thread
In Lavastorm I used if ... then abort("with some description of the error") How do we do the same thing in D360?

RE: Data will not appear in data viewer after running data flow

Posted By Sarita Gerbig 10-07-2020 08:49
Found In Egroup: Data360 Analyze \ view thread
Adrian, Yes the problem is when I am attempting to view the data in the Data Viewer. The node indicates there are records and they are recent records. I am having the issue again today. Data presents at every output in the dataflow but I can't view any of it. I was looking at this data yesterday ...

Remove existing Run Properties and replace with Property Set

Posted By Sarita Gerbig 10-06-2020 15:44
Found In Egroup: Data360 Analyze \ view thread
I don't believe I can use the RUN PROPERTY SET after already having run properties set up in a data flow .... or I don't know the process to do that. I deleted the existing run properties and pulled in the Run Property Set and hoped to be able to use the defined run set properties with database ...

Error parsing a field - error decoding field

Posted By Sarita Gerbig 09-24-2020 13:49
Found In Egroup: Data360 Analyze \ view thread
I am getting several of the same type of errors when I try to sort data or aggregate after miscellaneous modifications (Unicode to String being one of them). I have found that by removing some lines of data where a name might an (A with a tilde on top) or an (apostro above an E) , the errors are ...

Data will not appear in data viewer after running data flow

Posted By Sarita Gerbig 09-21-2020 15:39
Found In Egroup: Data360 Analyze \ view thread
I can see that data was produced at every node in my data flow but get an error telling me to check back later. What might be the cause of this? I've checked back later and still have the problem. Right now, my option is to re-run this rather large data flow. Data360 Analyze v3.6.3.6510

Takes a long time to updating a data flow before actually executing

Posted By Sarita Gerbig 09-21-2020 15:28
Found In Egroup: Data360 Analyze \ view thread
I'm just wondering how many people experience long waits while a dataflow updates (the blue circle goes round and round) before it gets to the actual execution (the green circle). In fact, while in the design phase, I spend probably 75% of my time waiting for the data flow to set up.... this even includes ...

RE: Promote a node from within a composite

Posted By Sarita Gerbig 09-21-2020 15:21
Found In Egroup: Data360 Analyze \ view thread
Is there any chance this function will be incorporated?