Multiple columns from one table into a single column
Thank you for your help, folks!!!!
Each EVENT has two or three PROGRAM_NUMBERS with corresponding CREDITS_EARNED for each prog_num
event title
prog_num_1
cred_1
prog_num_2
cred_2
prog_num_3
cred_3
event a
xyz
1
abc
2
fgh
1
event b
xyz
1
abc
3
Each CUSTOMER is affiliated with one or more EVENTS.
At the end of the day, I need to produce this:
Customer 1
event a
xyz
1
Customer 1
event a
abc
2
Customer 1
event a
fgh
1
Customer 1
event b
xyz
1
Customer 1
event b
abc
3
Customer 2
event b
xyz
1
Customer 2
event b
abc
3
Page 1 / 1
Hm, if an Event can only be linked to one Customer at a time, then I think I’d use an automation to create one record per program in another table to get the format you want, and I’d use a conditional to filter out the third program if it didn’t exist:
If each Event can be linked to multiple Customers, then I’d create a ‘Tasks’ table and have an automation that would create one record in there per Customer tied to an Event, and so each record in there would represent a single Customer <> Event link, and then I'd run the automation above on that new table instead
THANKS! I’m working my way through this. I think this might do it.
I have a CUSTOMERS table with links to each event and a column of aggregated programs (A customer can enroll in multiple events)
I have an EVENTS table with a column for each program
I have a REGISTRATION table with “customer_id” and “event_id”
I’m assuming that by using the Automation, I’d be creating a new table altogether (aka “Tasks”, per your comment)
Hmm, so there’s no direct link between Customers and Events, is that right? It sounds like you could make the automation trigger off of the Registration table instead actually, I’m not sure though, could you provide screenshots of your tables?
Thanks so much for the guidance I was new to Automations and did not understand their utility. All fixed now!
Not sure if you still need help as you provided the screenshot but it sounds like you’re all good? Glad you figured it out if so!
