Hi All,
I have a online reputation dataset using the tripadvisor connector. In the olden days this used to be an imported data table / project which you could add extra fields via the D&A section. However that no longer seems possible. My challenge is that I need to remove the time part from the created date field so that I can more easily group the dates together into custom period ranges in a dashboard dataset settings page.
I’ve tried a merge task but the data table is not accessible. In fact most workflow tasks don’t seem to be able to access it.
Does anyone have some alternate solutions to this? Can an API script be used to manipulate the created date (we don’t need time, just the date).
Thanks
Rod Pestell