Avatar

Geoff

  • Total activity 130
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 12
  • Subscriptions 34

Posts

Recent activity by Geoff Sort by recent activity Recent activity Votes
  • GET newest FTP file?

    Is there a way to get the most recent file that matches a pattern? some days multiple files are created and I need the newest one... exampleWIN_APF_03092020100544.csv WIN_APF_03092020021851.csv WIN...

  • Blank property possible?

    I would like to have a property that, if left blank.. gets a default value. Im thinking it wont work. in a python node  FLD="DEFAULT" FN="{{^FolderName^}}"if FN is not None:     FLD=FN   it breaks ...

  • Excel import and Modify Fields (Unicode to date)

    I have an excel sheet that I import that occasionally has fields that are null. I cant Modify these to what is needed. Example From_Date on the sheet is null. I tried importing as is, so excel sets...

  • Check for Zero records (Record Count)

    I need to check for a record count.. if 0 records output one value, otherwise output another... So I tried using an agg and doing a count... which outputs no rows if zero...  so in my transform nod...

  • FTP Get server path is added to the local path?

    when I use the FTP get node, it is adding the server path to the Local path.. so basically its putting the files in {{^FolderPath^}}APFEED/ this doesnt seem right.. the Local path should not have ...

  • Merge "Advanced" disappearing code

    Im not sure if this is just me? I add a merge Node, set up some details... then i go into the advanced section for configure fields any time change focus to something else and come back, as soon a...

  • "is None" doesnt work?

    according to your python cheat sheet (https://support.infogix.com/hc/en-us/articles/360037751033-Python-Cheat-Sheet) using "is None" should work to detect Nulls. it doesnt I have to use ==Null also...

  • Combining Rows

    Im stuck.... so I have a set of data, where there may be duplicates.. I need to combine them in a certain way. below is a "sample" I always need combine row 1 and 2, keeping the data in row 2. if ...

  • Unzip with password

    I found the lna for unzipping with python.. but I need to do it with a password. I tried zip_ref.extractall(path,pwd='test') but it tells me bad password for file i know its test since i can manual...

  • FilenameExpr for CSV gone?

    In lavastorm with csv file input nodes, you can pass in a Field for the file name... I do not see this in D360? I tried adding it as a parameter but it does not work? Its still there for the Excel ...