Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having an issue in matching periods/months that head a crosstable to dates in a text file. Attached are examples of my data files, the output [actual generated versus what I need] and the QV document.
I have tried to change the headings to actual month names, did not work.
I go for easy solutions. So if the headings of the crosstable need to be changed, that can be done.
Who can help me?
thanks
Hans
Try:
Directory;
LOAD YEAR(Date) as Year,
Text(Date(Date,'MM')) as Period,
if you do not mind, could you elaborate issue in way that no need to look into attachments?
Try:
Directory;
LOAD YEAR(Date) as Year,
Text(Date(Date,'MM')) as Period,
Hi Robert,
That just did the trick. Thank you for your help.
beste rgrds
Hans