(Classic) Transform Key value pairs into separate columns

Question

Hi,I have a question regarding changing typical JSON key-value pairs into DB columns.Here's the data schema I'm currently trying to transform:user channel optstatus1Emailtrue1SMSfalse2Emailtrue2SMStrue3Emailfalse3SMStrue I want to take the value pairs from "channel" and "optstatus" and create a new column in the data schema that would be fed with its values, something like this:user channel optstatus Email SMS1Emailtruetruefalse1SMSfalsetruefalse2Emailtruetruetrue2SMStruetruetrue3Emailfalsefalsetrue3SMStruefalsetrue Or to simplify something like that would be also good:user Email SMS1truefalse2truetrue3falsetrue I don't wanna change the already-existing structure of the data schema apart from adding new columns. Would I do it in a workflow, query and enrichment, or do some SQL filtering? I would really appreciate your help. Cheers!

Kishore_Padamata · Accepted Answer

Hello @piotrko2
Please try below approach:
-> [split] Split by channel

-> [enrichment] set @emailOPT with optstatus (the inbound transition value)

-> [enrichment] set @smsOPT with optstatus (the inbound transition value)
-> [union] chose selection of columns for reconciliation. set user as reconciliation key.

Hope this helps!

david--garcia · Answer

Can you elaborate more? whats your end goal? also, is your source schema custom? or ootb?

1	Email	true	true	false
1	SMS	false	true	false
2	Email	true	true	true
2	SMS	true	true	true
3	Email	false	false	true
3	SMS	true	false	true

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded