community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

Need to get File Creation Date from Mainframe

I was downloading one file from Mainframe via Download Tool using ftp properties I have given. While downloading I need to get file creation date in Mainframe ? Actually I already getting File referred date.

Below was the sample I was getting as of now

 

Volume Unit   Referred   Ext Used Recfm Lrecl BlkSz Dsorg Dsname
TST090 3390 2019/09/11 4 134 VB 2000 27998 PS G0060V00
TST269 3390 2019/09/11 5 140 VB 2000 27998 PS G0061V00
TST358 3390 2019/09/11 4 135 VB 2000 27998 PS G0062V00
TST185 3390 2019/09/12 5 138 VB 2000 27998 PS G0063V00
TST341 3390 2019/09/12 5 138 VB 2000 27998 PS G0064V00

 

Alteryx
Alteryx

@cetricelaens You can use the download tool with the GET request to get a list of all the files. Once done, you can sort the files based on date modified and join with the actual file based on the file name. 

Digan
Alteryx

Yeah via GET request and Download only , I got below data. But If you can see am just getting Referred Date but need Creation Date.

 

Volume Unit   Referred   Ext Used Recfm Lrecl BlkSz Dsorg Dsname
TST090 3390 2019/09/11 4 134 VB 2000 27998 PS G0060V00
TST269 3390 2019/09/11 5 140 VB 2000 27998 PS G0061V00
TST358 3390 2019/09/11 4 135 VB 2000 27998 PS G0062V00
TST185 3390 2019/09/12 5 138 VB 2000 27998 PS G0063V00
TST341 3390 2019/09/12 5 138 VB 2000 27998 PS G0064V00

Highlighted
Nebula
Nebula

Hi @cetricelaens 

 

You can only retrieve columns that the FTP server includes in the directory listing.  The configuration options to change the list of columns varies by FTP server, so you'll have to research the specific FTP server your calling to see if there's some way to add the created date to the returned columns

 

Dan

Labels