Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
nehajain2384
Contributor
Contributor
‎2020-07-13 07:02 AM

Generate CSV for new records only

Hi Expert,

I receives a qvd which has 24 months data in it and i have to generate a CSV file for each month , which i am doing using loop.

 

But my code should not generate the already generated CSV again when i receive new qvd with 25 Moths data (24 Old + 1 New)

Could someone help me with logic.

 

Regards

Neha

297 Views
0 Likes
1 Reply
sk88024
Contributor III
Contributor III
‎2020-07-13 11:07 AM

Hi Neha,

Please confirm if my understanding is correct about your requirement - 

1. You receive a QVD file having 24 Months data, and you're generating 24 CSV files for each month. 

2. Now, you receive a QVD file again having 25 Months data (24 Months Old data and 1 Month new data). Since you already have generated CSV files for 24 Months Old data earlier, now you just want to generate one file for the 1 Month new data. 

So, to summaries your requirement - it should generate CSV files only for the new month data? Is that right?

If yes, can you please provide some of your samples data, better yet the script you are using. It will help us to find the solution. 

264 Views