How can I fill a field with info from another field

Copper Contributor

Oct 06, 2023

I'll have to modify the xlsx before uploading. (personal information stuff)

Bronze Contributor

Oct 06, 2023

How about convert the Excel sheet layout like below before import to Access?

Then I guess use transform pivot sql.statements.

//select * from split_then_transform limit 20;

cli_split_data~split_then_transform~,~ROLES;

select NAME,EMAIL,ROLES name from split_then_transformsplit;

source and expected result:

NAMEEMAILROLES

John Doe	email address removed for privacy reasons	role1,role3
Jane Doe	email address removed for privacy reasons	role2,role4
Jim Doe	email address removed for privacy reasons	role4
John Smith	email address removed for privacy reasons	role1

NAMEEMAILname

John Doe	email address removed for privacy reasons	role1
John Doe	email address removed for privacy reasons	role3
Jane Doe	email address removed for privacy reasons	role2
Jane Doe	email address removed for privacy reasons	role4
Jim Doe	email address removed for privacy reasons	role4
John Smith	email address removed for privacy reasons	role1

Forum Discussion