Open fraserward opened 2 years ago
Since the new logic to make leads converted dates work in the CSV files we now have all 10K records in demo data with converted dates.
This should now be modified with a transformation that looks at all records and does this logic:
If Record in D_LEAD column 'LEAD_STATUS <> 'Converted' then in the F_LEADS the 'LEAD_DATE_CONVERTED_TK' column should be replaced with '29991231'
same as suitercrm-powerbi project ticket 22
Since the new logic to make leads converted dates work in the CSV files we now have all 10K records in demo data with converted dates.
This should now be modified with a transformation that looks at all records and does this logic:
If Record in D_LEAD column 'LEAD_STATUS <> 'Converted' then in the F_LEADS the 'LEAD_DATE_CONVERTED_TK' column should be replaced with '29991231'
same as suitercrm-powerbi project ticket 22