Email ID column overriding

Hi Team,

Hope you are doing Good!

I have "Email ID" Column, using data shuttle I'm moving data to that Column so in my input file that Email Id column will come with both person Email ID and Official Mail ID, first time personal and second time official and vice versa.

I need to split this, if personal ID comes put it in one column and official ID means put it different column.

IS there any way to achieve this.

Kindly help me on this.

Thanks,

Sandhiya P

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Sandhiya07

Are you able to post screen captures of your source sheet set up and your destination sheet? (But block out sensitive data).

If you have an identifier on the source sheet rows that tells you whether it's Email or Official Mail, you could use two different Data Mesh workflows: each workflow would have a Filter so it only brings over the rows with "Email" or "Official" and then you can change the mapping to go into different columns in the different workflows.

Cheers!

Genevieve

All comments

Genevieve P.

Hi @Sandhiya07

Are you able to post screen captures of your source sheet set up and your destination sheet? (But block out sensitive data).

Cheers!

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.