Hi All,
Hope you are doing well..I am trying to convert a plan table as below
into the table below based on the current date and the reference table
Reference table:
So I need to basically map the column names (FC1,FC2,FC3...input table) to fiscal month based on the current date and looking up the reference table for the fiscal month... I have attached the excel data for the above too...Can you please help me with the beast mode or ETL for the same...