Question about transform data

[Anonymous]

Hi Everyone,

Date

In the transform data section, I want to create a duplicate column for created date which shows 1/2/2022 4:12:30 AM but the new column it will show it as Jan-2022. How can I do that?

Missing Group:

If I go to transform data, in the column group names I see all the groups except for the name DOBA (which I want to see). Even if I change to sheet to column profiling based on entire data set. But when I am in the data section and go to column group DOBA appears. Why is it that it does not show up on transform data? Because I want to filter it out from there.

[v-henryk-mstf]

Hi @Anonymous ,

Whether the advice given by @jsaunders_zero9  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly.

If not, please point it out and provide test data.

Looking forward to your feedback.

Best Regards,
Henry

[jsaunders_zero9]

For the missing group question how many records are you pulling in? PQ only shows the top 999 by default it could be that the particular result you are looking for is below that.

[jsaunders_zero9]

Some examples/images might help to get you a solution.

[jsaunders_zero9 · Accepted solution]

For the date question, try adding a custom column with this formula.

DateTime.ToText([Created Date],"MMM-yyyy")