Find matching column and add data to QVD.

[ashishp]

HI There 

I have to create QVD for following condition. 

I am receiving columns for latest month  with column name  "July 2022". In the existing data source I have Columns name "July 2022" already present. 

Every month data is added in the source database with latest month columns name. Compare the latest month column  name with previous year column name and add both columns to QVD.

("July 2022" and "July 2021")

Thanks in advance.    

[vidyutverma]

You need to describe it better with some examples and purpose of this task. This may help in getting it answered.

[ashishp]

Please find attached data example. 

We got column C as latest month data (FY 22 June). Now find similar month data from all columns for previous year. i.e  FY 21 June. 

Take these 2 columns (column C and Column G)and create QVD. 

[vidyutverma]

I would suggest using Crosstable on the imported data so that you get the monthnames in a field and corresponding values in another. Also because the column names are changing everymonth, its better not to use those as header in the script.