topic Re: Find matching column and add data to QVD. in Connectivity & Data Prep

Find matching column and add data to QVD.

ashishp — Thu, 28 Jul 2022 14:19:00 GMT

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.

Re: Find matching column and add data to QVD.

vidyutverma — Thu, 28 Jul 2022 18:32:21 GMT

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

Re: Find matching column and add data to QVD.

ashishp — Fri, 29 Jul 2022 07:27:12 GMT

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.

Re: Find matching column and add data to QVD.

vidyutverma — Sat, 30 Jul 2022 09:41:38 GMT

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.