topic Re: Possible issue with variable when storing a file in QlikView

Possible issue with variable when storing a file

QFanatic — Sat, 16 Nov 2024 00:02:01 GMT

hi guys,

I need some expert advice here...I have never seen anything like this happening...for this kind of statement.

I have a model that writes a table out as a csv file.

The statement I use to write it is:

store Final into $(vQVData)\$(vProductSN)_$(vEventDate).csv(txt) - where Final is a Table...

I sometimes get the following error...and usually with the same file -

(System error: Filesystem::FindImpl FindFirst call: Incorrect function: "C:\Users\f4645332\OneDrive - FRG\Documents\Documents\A DIGITAL\QVData\A Test")
2020-09-03 09:07:26 2924 store APP_DDA25 into C:\Users\f4645332\OneDrive - FRG\Documents\Documents\A DIGITAL\QVData\A Test\Monthly\APP_DDA25_202008.csv(txt)

The file in Question, APP_DDA25_202008.csv(txt) , contains only headings.

What bugs me about this is that I read many of these (empty) files - why is only this one giving an error?

Oddly enough - if I remove my variable (vQVdata) and place the entire url - it works....so I'm guessing it has to do with the dollar expansion?

Any ideas please?

Thanks

Re: Possible issue with variable when storing a file

eliran — Thu, 03 Sep 2020 15:08:28 GMT

Hi,

Can you show the variables formula?

Re: Possible issue with variable when storing a file

QFanatic — Fri, 04 Sep 2020 05:25:34 GMT

Hi,

vQVData = 'C:\Users\f4645332\OneDrive - FRG\Documents\Documents\A DIGITAL\QVData\A_TEST'

vProductSN = 'ABC_99'

vEventDate = date(floor(monthend(addmonths(Today(),-1))), 'YYYYMMDD')

Thank you

Re: Possible issue with variable when storing a file

marcus_sommer — Mon, 07 Sep 2020 12:49:13 GMT

As fas as the full-path contained spaces or any kind of special chars the full-path needs to be wrapped. Therefore try:

store Final into [$(vQVData)\$(vProductSN)_$(vEventDate).csv] (txt)

- Marcus

Re: Possible issue with variable when storing a file

QFanatic — Mon, 07 Sep 2020 13:28:41 GMT

Awesome Marcus, you're a star!