topic Re: How to use monthend qvd when new fields added in recent month qvd in App Development

How to use monthend qvd when new fields added in recent month qvd

rkpatelqlikview — Sun, 09 Jun 2019 10:56:13 GMT

Dear Team,

Here i am facing an issue with monthend sales qvd's.

Every month end am storing sales in (30-4-2019-sales) QVD and calling with *-sales. It will call all the sales with existing months. But now suddenly new fields added in 5th month. now QVD name is 30-5-2019-sales.

FROM [...QVDLOAD\MonthEnd\*-sales UAE.qvd]

Now i want take the data along with the new fields. how can merge this fields data.

Is there any way to put prefix FROM [$(QVDLOAD)MonthEnd\ >=30-5-2019Sales UAE.qvd] ???

Thanks in advance.

Re: How to use monthend qvd when new fields added in recent month qvd

rkpatelqlikview — Sun, 09 Jun 2019 12:27:26 GMT

This is typical and good in real time scenario. Please let me know if any one not understand the query.

Re: How to use monthend qvd when new fields added in recent month qvd

bing_jville — Sun, 09 Jun 2019 21:10:24 GMT

Nothing is needed to done with the part - "FROM [...QVDLOAD\MonthEnd\*-sales UAE.qvd]"
I think the only change is in the loading script of the final app. e.g.
IF(QvdLoadDate>'01-05-2019', NewField, 'na') as NewField

Find a suitable date to use in the monthly QVD for this IF statement - IF older than May, load the value as nothing.

Re: How to use monthend qvd when new fields added in recent month qvd

rkpatelqlikview — Mon, 10 Jun 2019 04:20:42 GMT

Thanks for your response Bing, I understood but

What is this QvdLoadDate? First of all in load script it will not take, will through error. Can you please give me a clarity on this?

Re: How to use monthend qvd when new fields added in recent month qvd

jonathandienst — Mon, 10 Jun 2019 06:27:40 GMT

I am not sure whether you want to dynamically add new fields or filter to load only May 2019, and later - but assuming a bit of both:

Result: LOAD 0 as FileDate AutoGenerate 0; For Each vFile in FileList('..QVDLOAD\MonthEnd\*-sales UAE.qvd') Let vFileDate = Num(Date#(TextBetween(vFile, 'MonthEnd\', '-sales UAE.qvd'), 'd-M-yyyy')); If vFileDate >= MakeDate(2019, 5, 30) Then Concatenate(Result) LOAD *, Date($(vFileDate)) as FileDate FROM [$(vFile)] (qvd); End If Next

Re: How to use monthend qvd when new fields added in recent month qvd

rkpatelqlikview — Wed, 12 Jun 2019 06:18:26 GMT

Hi Jontydkpi,

Thanks for your response. Yes I need dynamically. If any changes happen in new QVD, it should take automatically from existing QVD also.

I will try with script which you have provided.

Thanks for guidance.