Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have issue with Data
Actually i have 346 rows i have in Excel
But i created month field ,for that i loaded same data in 12 Times
Now i have 4152 rows i have
when i use count of rows 4152 its showing ,but actually 346 only
How can i Fix this issue please some one help me
I am attached QVW please find the QVW
Thanks In Advance
Niranjan
When you load the data, the MonthDesc contains the months. When you select a month, it will show associated results. Are you attempting to duplicate the information? If not, then simply load the script once (no concatenation, use the original (top) load script once. It will contain 342 fields. Otherwise - you will have duplicated data that will exceed 342 as Jacob explains.
-Greg
when i use no concatinate i wont effect my data
can i use No cancatinate ,guide me i dont know exactly in this secnario
Best Regards,
Niranjan
Can you share the data source with me?
Are you able to insert a "date field" into the load script? If you can, this would greatly simplify your challenge. You could script month(<date field>) and you would be able to limit your data. Or perhaps, if you have xls files that have different months - these can be loaded and concatenated.
Hi Greg Williams,
Sorry for late response ,i attached Excel dump
please find the attachement
how can i insert date field i dont know this concept could you please guide me
how to do this
Best Regards,
Niranjan
Hi, Niru Niru.
Here is a modification of your QVW that I think will show you how to solve your problem. I'm going to attach the same file to your other posts about this issue too.
Hope it helps.
Bruno.
Load *,
month(date#(left(right(trim(filebasename()),6) ,3) ,'MMM')) as Month,
Year(date#(right(right(trim(filebasename()),6) ,2),'YY') ) as Year
from c:\book1.xls;
hi ,
in bar chart how can i show dollars comparison and SQF comparison
Regards,
Niranjan