Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
I'm hoping someone might be able to assist with some trouble I'm having sorting out some oddly formatted data. Below I've approximated what my data looks like (except that there are many more themes). What I want ultimately is a new dimension called "Theme" which would consist of "Service" and "Brand" in the below case. There would then be two instances of the "Service" theme (one negative and one positive) and another instance of the brand theme. I've pasted my envisaged table under "Targeted" below. Does anyone know how I might be able to accomplish that? Any help would be greatly appreciated.
Current:
ID | Positive Theme 1 | Positive Theme 2 | Negative Theme 1 | Negative Theme 2 |
---|---|---|---|---|
1 | Positive Service | |||
2 | Positive Brand | Negative Service | ||
Targeted Table:
ID | Theme |
---|---|
1 | Service |
2 | Service |
2 | Brand |
Hi Nathan,
Please find the attachment for the solution:
I have designed the above solution based on your question inputs , actually what is the exact requirement??
so that we can guide you on the proper path to achieve your requirement
Hey There, that is perfect for my needs. Thanks so much