Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am sharing an excel having my query for reference.
I need to assign the measure at month year level to supplier.But it's getting total to all like below.
Thanks..
you need to split up the MonthYear_CFM into 2 separate fields. Month and Year
you can do this via the Datamanager or via the dataload script.
I myself prefer the dataload script. there you can add this to the load statement when loading in the table
Load *
subfield(MonthYear_CFM,' ', 0) as Month,
subfield(MonthYear_CFM,' ', 1) as Year
From [LOCATION]
then you can create 2 tables with
1. Supplier_Name, Month, count(DateType_CFM)
2. Supplier_Name, Year, count(DateType_CFM)