Script to read from csv file names and create a field in QVD

[Anonymous]

I have hundreds of CSV files, there is some information coming through file name (like category etc) I need to capture that information while creating a QVD from a CSV so the information captured (from file name) becomes an additional field in QVD. Any suggestions?

[#2 · Accepted solution]

Hi,

LOAD *, FileName() as TableName

FROM Table;

Regards,

Ricardo