Skip to Content
0
Jan 18, 2020 at 04:14 PM

XSA Virtual table - how to read the file with date time stamp

95 Views Last edit Jan 18, 2020 at 07:19 PM 2 rev

Hello HANA XSA Guru’s,

We have requirement to read the file daily basis that mean we have the file with DATESTAMP.

Example: FILENAME_20200118.csv so we schedule a flow graphs runs daily and we tried with FILENAME_%.csv but it picks all the files. The requirements is the virtual table should pick up only today's file.

Note: I tried with FILE NAME PATTERN = FILENAME_’yyyy.MM.dd’.csv but we get an error as “file do not exist….error”

Anyone can help us ? thanks

Regards,

Manoj Reddy

+1 647 856 4664

Attachments

virtualtable2.jpg (92.7 kB)